Skip to main content

"If" date formula help needed

  • October 13, 2017
  • 1 reply
  • 15 views
R
Forum|alt.badge.img+4

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

    This topic has been closed for replies.

    1 reply

    E
    Forum|alt.badge.img+17

    That is working for me:

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

      Terms & ConditionsAccessibility statement