Conditional Formatting with dates

Options

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!