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