Setting "Date Completed" column date based on status change

edited 12/09/19 in Formulas and Functions

Hi! I'm trying to set up a formula for my Date Completed column that pre-populates the date in that field to the date where the Status on the same line = "Complete".


Right now I'm using this formula: =IF(OR(Status125 = "Complete"), TODAY(), "")


One problem is that it doesn't add the formula for newly added line items. Also - it literally changes the date to "today" and doesn't remember when the status flipped to "Complete".


Any help is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!