Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 19, 2019 01:35 PM
Is there a way to only have a formula to show in one cell?
I have a smaller table where I want to pull totals from two other tables then total those results to display…ie wages less expenses…is there a way to calculate this in only one row to yield the result across 12 months displayed horizontally?
Emma
Dec 19, 2019 04:28 PM
Yes and no.
No, you can’t have a formula that only operates in a single field of a single record, and doesn’t run at all in the same field for other records. A formula field runs its calculations for all records.
However, you can design the formula to only run the main calculation(s) when a specific condition is met, and then only trigger that condition in a specific record. For example, the formula could be something like this:
IF(Name="Total", [the rest of your formula here])
Only on the record where the {Name}
field is set to “Total” would the main part do its thing. On all other records, it would leave the field blank. I haven’t used this technique very often, but it has come in handy on a couple occasions.