Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Help With Formulas


I am attempting to automate the RYG column shown in the screen shot below.  I need the formula to look at the finish date and status columns if the status is not "Done".

I need some feedback on the formula that I am using below.

https://d.adroll.com/cm/index/outhttps://d.adroll.com/cm/n/out=IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(), "Green", IF(AND[Status]1 = “Done”, “Green))))



  • Shaine Greenwood

    Hi Jennifer,

    Your images didn't make it through. I'm not sure what feedback you're looking for, but I can see a few issues with the formula you copied into your discussion:

    1. It combines straight quotes and curly quotes. Please make sure to only use straight quotes.
    2. You have an IF(AND()) statement at the end with no second condition. I think you're wanting to combine the last two statements, the last part of your formula should look more like this: ...IF(AND(Finish1 > TODAY(), Status1 = "Done"), "Green")))
    3. You're missing quotes on the text string of "Green" at the end of your formula.
  • Thank you.  I got the formula to work with your help.

  • Shaine Greenwood

    Yay! Glad it's working for you.

This discussion has been closed.