Welcome!

Formula

VERY new to SS. I am trying to write a formula that will insert red dot for any date that is prior to today, a yellow dot for any date that is that is between 1-30 days from now, and a green dot for any date that is 30+days from now and I cannot get it to work...can anyone provide guidance?

Find more posts tagged with

Comments

Andrée Starå

Hi,

Can you provide the column names and some screenshots?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nic Larsen

Try this:

=IF([Column Name]@row > TODAY() + 30, "Green", IF([Column Name]@row < TODAY(), "Red", "Yellow"))

Mike Wilday

You will want to create a new Symbol column set up as a RYG column. Use Nlarsons formula in the new RYG column. Then replace "Column Name" with your date column name. You'll want to make sure that the column with the due date is also a date column type. You can right-click on the column header and choose "Column Properties" to determine if its a date column or not.

Sign in to join the conversation!

Quick Links

Trending discussions

User Types for Update Requests/Forms
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
Generating documents from row data
This discussion was created from comments split from: Generate documents from row data.
Getting error - need help!
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday