Setting "Date Completed" column date based on status change

JesseE
JesseE
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!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!