Looking to have a RAG status based on Status and Date

Hi all- Looking for some help. Trying to create a RAG status (red, yellow, green, blue) that takes into account an expected completion date as well as a status (Not Started, In Progress, Pending, and Complete)

Rules:

Task in Complete state should be Blue

Task that is in Progress or Pending before the Expected completion date is Green

Task that is in Progress or Pending up to 2 days after the Expected completion date is Yellow

Task that is Not Started and Today = Expected Completion date is Red

Task that is not in Complete State and 3 days past Expected Completion date is Red.

Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!