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

jennifer.cooper15596
jennifer.cooper15596 ✭
edited 12/09/19 in Archived 2017 Posts

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))))

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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.
    · Share on FacebookShare on Twitter
  • jennifer.cooper15596
    jennifer.cooper15596 ✭

    Thank you.  I got the formula to work with your help.

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Yay! Glad it's working for you.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories