Hi!
I’m trying to create a formula to calculate the age our participant (board item) was at the time they participated in our program (timeline)
Currently the formula I have is:
IF({Birthday},INT(YEARFRAC({Birthday}, {Program Date#End})),“undetermined”)
This formula works, however if the program timeline column is left blank, it generates the exclamation point error. I would like it to also say “undetermined” or “n/a” instead of the error message.
Your help is appreciated!