Conditional formatting(?) based on a date column and second column

KGF

I'd like to add a column to my SS (call it Column C) that will denote if an answer was entered into column B on or after a date shown in Column A. I'm thinking conditional formatting is the answer, but I'm open to other options.

Ideally, I'd like to know if Column B was changed on or after three days before the date in Column A.

Janae G.

In order to check when a cell in a column was changed, you would need some kind of record kept in another column to denote the date that the change occurred. Smartsheet cannot use cell history or changelogs for conditional formatting or in formulas as far as I am aware.

One way to do this would be to set up a Smartsheet automation to add a date when Column B changes (can set up logic for changes to something specific, changes to not blank, etc.). So this column, say Column D, is a date column that records when something was entered into Column B.

I don't think conditional formatting can compare two date columns… but you could achieve what you need with a column formula that checks if Column D is on or after Column A.

So your Column C would be a flag/checkbox field with a column formula similar to this:

=IF([Column D]@row >= [Column A]@row, 1, 0)

You could then add conditional formatting to highlight the row based on the value of the checkbox in Column C if you want.

Hope this helps!

Janae G.

In order to check when a cell in a column was changed, you would need some kind of record kept in another column to denote the date that the change occurred. Smartsheet cannot use cell history or changelogs for conditional formatting or in formulas as far as I am aware.

One way to do this would be to set up a Smartsheet automation to add a date when Column B changes (can set up logic for changes to something specific, changes to not blank, etc.). So this column, say Column D, is a date column that records when something was entered into Column B.

I don't think conditional formatting can compare two date columns… but you could achieve what you need with a column formula that checks if Column D is on or after Column A.

So your Column C would be a flag/checkbox field with a column formula similar to this:

=IF([Column D]@row >= [Column A]@row, 1, 0)

You could then add conditional formatting to highlight the row based on the value of the checkbox in Column C if you want.

Hope this helps!