Help

Conditional in a RollUp

Topic Labels: Formulas
760 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Suraj_Kapoor
5 - Automation Enthusiast
5 - Automation Enthusiast

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.