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
Try this:
=IF(Completed23, "", Date23 - 3)
for row 23.
Craig
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.
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)
And yet you indicate --- for row 23. Makes sense.
