Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
