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.

Date Formulas

Options
Tiare Rose
edited 12/09/19 in Archived 2016 Posts

I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off??

 

Tiare

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭
    Options

    No, the closest you could get is recording the last time a row was edited, but if someone performs another action on the row you could not retain the date when the box was checked.

     

    Workaround: Change the check box column to a date column and title it "Date Completed'.   If there is a date there, the task is complete.

This discussion has been closed.