Help with "IF CONDITION" in an automation for "whe...

[Rebecca_Pike]

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

[Elias_Gomez_Sai]

That is working for me:

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

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...