Autofill Date Column with Conditional Formatting

Gabby Rosa

Hi there,

 

I am trying to set up an approval sheet. 

 

I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed.

 

Can anyone help me with this formula?

 

Thank you

J. Craig Williams

Try this:

=IF(Completed23, "", Date23 - 3)

for row 23.

Craig

Mike Wilday

Craig - Why do you always use 23?   -- Once you drag that formula up and down to all of your rows, I recommend deleting all of your blank rows at the bottom to ensure that new rows that are created by Smartsheet will contain your formula and implement the auto-fill feature.

J. Craig Williams

re: 23 --- Robert Anton Wilson (who cites William Burroughs as the source, but I read RAW first)

It is also less likely to be mistaken for part of a column name (like 1 or 2 may be)

Craig

 

Mike Wilday

And yet you indicate --- for row 23.  Makes sense.