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

Conditional in a RollUp

Topic Labels: Formulas
218 2
Showing results for 
Search instead for 
Did you mean: 

Hi! I am trying to write a conditional formula on a rollup…

In table A, I have a dropdown column (“sponsored”) with multiple options, not all rows have a dropdown against them. I have table B that has a rollup column, that I would like to sum the values IF the row in table has a dropdown against it. I am using…

IF({sponsored}, SUM(values))

…but it’s not working!

2 Replies 2

You set the conditions in a conditional rollup in the field configuration, not in the formula for the rollup.

Yes!! Thank you that worked.