"If" date formula help needed

3075 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m trying to create a formula, where if today’s date is greater than the expiration date, it will yield a red X. This is what I have so far. It’s not quite right, but I can’t figure out what to fix.

IF(IS_AFTER({Expiration Date}, TODAY( )), “ :white_check_mark: ”, “ :x: ”))

Please help!!

thank youS

1 Reply 1

That is working for me:


Be sure that the emojis are between this: " or '.