Fill a column with a value based on the date of another column


I have a "Status" column where users can select "Completed" from a drop down list. There is another column called "Due Date" that already has value plus a third column called "Timeliness".

What I would like is...when a user select Completed on the Status column, it will enter "Late" in the "Timeliness" column if the current date (e.g. when users marked it as completed) is later than the date set on the "Due Date" column.

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓


    After creating the Date Completed column, set up an Automation as follows:

    Timeliness column formula:

    =IF(AND(Status@row = "Completed", [Date Completed]@row <= [Due Date]@row), "On Time", "Late")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!