Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Autofill Date Column with Conditional Formatting

11/29/17 Edited 12/09/19

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 WilliamsJ. Craig Williams Top Contributor

    Try this:

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

    for row 23.


  • Mike WildayMike 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 WilliamsJ. Craig Williams Top Contributor
    edited 12/01/17

    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)



  • Mike WildayMike Wilday ✭✭✭✭✭

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

This discussion has been closed.