"If" date formula help needed


#1

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


#2

That is working for me:

image

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