RAG Rating Formulas

Options
handmadetsunami
handmadetsunami ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi,

I am struggling with RAG rating formulas (and its something that I have done before but I can't get my head around it at the moment!)

I am trying to do the following tasks:

Regardless of the end date, if % complete is 100%, then show a green rag rating

If the finish date is within 30 days and the % complete isn't 100%, then show a yellow rag rating

If the finish date is within 15 days or in the past and the % complete isn't 100%, then show a red rag rating

I have attached a screenshot to show how the sheet is laid out

 

RAG.jpg

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!