Skip to main content

Conditional in a RollUp

  • March 19, 2022
  • 2 replies
  • 19 views

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • March 19, 2022

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


  • Author
  • New Participant
  • March 19, 2022

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


Yes!! Thank you that worked.