Hello Smartsheet friends,
I've found several past due or days before past due formulas but have not been able to find one specific to this case.
We use a smartsheet for account management. I would like to have a cell turn a color based on the variables below, based on how many days have elapsed past the date in another row. There is no due date on this sheet. I simply need to draw attention to a column that needs to have a scheduled date within 21 days of the date in another column.
I greatly appreciate any help you can provide. Thanks in advance friends.
Column A - 1/1/2021
Column B
Green - 1-7 Days past the above date
Yellow - 8-16 days past the above date
Red - 17+ Days past the above date
When a date has been entered in another column, it would stop the counting or turn it blue.
