Hey @artoflogic, first of all, I wanted to clarify that the way the database works, it’s impossible to run formulas at the field level; they only work at the row level. However, for simple field calculations, we have a footer aggregations feature: Footer aggregation // Baserow.
Now, about the request:
While discussing your idea, we found it very interesting. Possibly, we could add formula or filter support to the footer aggregations, allowing users to make more advanced data analysis at the field level. On the other hand, we plan to start working on the dashboard feature soon, and it might also partially solve your issue.
We think many Excel users will find this new feature helpful. So, we’d like to understand more use cases for it to find the best solution for its implementation. I’ve started this thread so we all can brainstorm together: Join the brainstorm! What are your thoughts on performing data manipulations and analysis at the FIELD level in Baserow?.
Looking forward to hearing your thoughts on this.