Formula for Auto RAG status

D@THOMPSON

Anyone help?

Using formulas, you can automate RYG balls to change colors based on the Due Date being 45, 30, or past the due date?

 

Thanks

Shaine Greenwood

Hello,

Try a formula like the following example:

=IF([Due Date]1 >= TODAY(30), "Red", IF([Due Date]1 >= TODAY(45), "Yellow", "Green"))

NOTE: This is an example formula, please refrain form copying and pasting it straight into your sheet as it may not work. You may need to adjust the formula to better suit your needs and match the correct cell references in your sheet.

Details on creating formulas can be found in our help articles:

• Create and Edit Formulas
• Functions list