I have a column of dates with conditional formatting that turns the cell Red if the date does not fall on a Monday. This works fine.
If the date is longer than 7 days in the past then I don't want the cell Red.
I have a helper column that returns a '1' if the date in the cell is more than 7 days old.
Now I want to add another conditional format that says 'if helper column = 1, then no cell background'.
Response from Smartsheet is
I can't figure this out.