nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

Find more posts tagged with

Comments

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:

Sign in to join the conversation!

Quick Links

Trending discussions

Form from different sheets
Can I create a form with information from different sheets?
If someone has multiple rows where their contact appears, can they just receive one email?
Hello, I'm trying to not spam the people I need info from. I have 600 courses and need the course owners to fill in some info for me. Some people are the contact for 30 courses. If I just send an automated request for an update, they'll get 30 emails. Can I automate an email so that each contact just gets one request if…
Users unable to update CheckBox
I use Smartsheet for our audit process. It has worked wonderfully all year but a new set of audits just came in and for whatever reason my team has lost the ability to check the completed check box in the sheet. I have checked to make sure the column is not locked, upgraded their permissions to admin. No luck. Screenshot…