Skip to main content

Hi all


I need some help with formatting a nested IF statement as I can’t understand why it’s not working. Here’s the background:


I have a {Start Date} field and an {End Date} field - both are formatted as “Date fields”. I want to check the current day - TODAY() against these dates and print out an emoticon depending on the result. I can get this single IF statement to work:


(If the END DATE is AFTER today, then print “ 🏇 ” (running!), if not, then print “ ✔ ” (completed!)


IF(IS_AFTER({End Date}, TODAY())=1,“ 🏇 ”, “ ✔ ”)


However I want to add a third condition for the future:


(If the END DATE is AFTER today, then print “ 🏇 ” (running!), If the START DATE is AFTER today, then print “ 🔮 ” (future!), if not, then print “ ✔ ” (completed!)


So I have this which doesn’t work and throws up an error:


IF(

IS_AFTER({End Date},TODAY())=1,

“ 🏇 ”,

IF (IS_AFTER({Start Date}, TODAY())=1,

“ 🔮 ”,

“ ✔ ”

)

)


What am I doing wrong?

Try the following formula:


IF(

   {Start Date} > TODAY(),

   "🔮"

   IF(

      {End Date} > TODAY(),

      "🏇",

      "✔"

   )

)

Try the following formula:


IF(

   {Start Date} > TODAY(),

   "🔮"

   IF(

      {End Date} > TODAY(),

      "🏇",

      "✔"

   )

)

Thanks Kamille!


I just had to add a comma after “ 🔮 ” (so “ 🔮 ”,) to get it it work.


Any idea why my effort didn’t do the trick?

Reply


Terms & Conditions