axelrodo ✭✭
edited 12/09/19 in Smartsheet Basics

I'm new to smartsheet and going through (a lot of) various tutorials on YouTube. I picked from the Save Time And Increase Efficiency -which I'm obviously not good at- a formula that updates the STATUS column (green, yellow, red dots) according to closeness to the DUE DATE column, which is:

=IF([Due Date]2 < TODAY(+28), "Green",

IF(AND([Due Date]2 >+ TODAY(+14), [Due Date]2 < TODAY(+28)), "Yellow",

IF([Due Date]2 >= TODAY (+14), "Red")))

When used separately, say only the green or only the red, the formula works. As soon as I have the IF(AND...etc... an error message appears with UNPARSEABLE. I've looked at other responses but since many use different formulas and I'm totally new to Smartsheet, I wasn't able to apply the solutions to this one. Could anyone help me out please?