Skip to main content
Solved

Enter value if my rollup is blank

  • July 13, 2021
  • 1 reply
  • 24 views

Forum|alt.badge.img+2

Hi,

I have a conditional rollup where I am doing an Arrayunique of events that occurred in a specific Academic Year.

If the array is empty (meaning, the event was not scheduled in said year), then I want the rollup field to say “Not Scheduled”. Is that possible? I currently am doing this by using the Rollup as a helper column, but would love it if I can do this all in one.

Best answer by Kamille_Parks11

Adjust your Rollup’s aggregation formula to be

IF(values, ARRAYUNIQUE(values), "Not Scheduled")

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

Adjust your Rollup’s aggregation formula to be

IF(values, ARRAYUNIQUE(values), "Not Scheduled")