Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Enter value if my rollup is blank

Topic Labels: Base design
Solved
Jump to Solution
533 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

Adjust your Rollup’s aggregation formula to be

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

See Solution in Thread

1 Reply 1

Adjust your Rollup’s aggregation formula to be

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