HELP:Automate Status for Range of Dates

I am trying to construct a formula that will make the status turn yellow when TODAY() is 4 days to and 4 days after the date in the [Due Date] column.

I was hoping the following would work but it does not:

=IF([Due Date]8 <> TODAY(4), "Yellow")

Any ideas on how to write an if formula to cover the date range?

Find more posts tagged with

Formulas

Comments

L_123

=IF(AND([Due Date]@row< TODAY(4), [Due Date]@row> TODAY(-4)), "Yellow")

I think that is what you are looking for

KandiceKnoelk

Thank you!

Sign in to join the conversation!

Quick Links

Trending discussions

How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…