Conditional Formatting with dates

appe1473

I am trying to figure out how to set a conditional format in smartsheet with dates.

Given one row with cells A, B, and C which are all dates (or blank):

Set Cell A to = Cell B, if Cell C = <blank> [that is, copy content of cell B into cell A]

If Cell C is not blank, then Cell A = Cell C [that is, copy content of cell C into cell A and ignore content of cell B]

The dates themselves to not matter, just whether a date has been entered or not.

Is there a way to do this?? All help appreciated!

Paul Newcome

Try this in [ Column A]:

=IF([Column C]@row <> "", [Column C]@row, [Column B]@row)

appe1473

Perfection, thank you!!

Paul Newcome

Happy to help. 👍️