Skip to main content

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!

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

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


Yes!! Thank you that worked.

Reply


Terms & Conditions