Jul 13, 2021 12:04 PM
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.
Solved! Go to Solution.
Jul 13, 2021 12:28 PM
Adjust your Rollup’s aggregation formula to be
IF(values, ARRAYUNIQUE(values), "Not Scheduled")
Jul 13, 2021 12:28 PM
Adjust your Rollup’s aggregation formula to be
IF(values, ARRAYUNIQUE(values), "Not Scheduled")