Help with formula with multiple conditions to auto-update RYG ball

I am trying to create a formula with multiple conditions in order to automatically change the color of the RYG ball.

IF the Status = Not Started/In Progress/Blank AND the End Date is less than TODAY () then the ball should be Red

OR IF the Status = Not Started/In Progress/Blank AND the End Date is in the next 7 days then the ball should be Yellow

otherwise the ball should be Green

I currently have this formula =IFERROR(IF([End Date]@row < TODAY(), "Red", IF([End Date]@row < TODAY(+7), "Yellow", "Green")), " ") but I just need to add other conditions for Red & Yellow status.

Thanks in advance for any help!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!