Hi,
I am currently trying to use an if formula to display emojis to highlight the status of a license (date field). I currently have:-
IF(IS_AFTER(TODAY(), {END DATE}), “ :stop_sign: EXPIRED”, IF(IS_SAME(TODAY(), {END DATE}), “ :calendar: EXPIRES TODAY”, IF(IS_AFTER(TODAY(), DATEADD({END DATE}, -1, ‘week’)), “ :warning: EXPIRES SOON”)))
The formula is working fine but I wanted to add ELSE display “ :heavy_check_mark: ACTIVE” but can’t seem to figure it out.
Thanks