Capture Close Date when form is "closed"


I currently have users submitting a form for internal requests. The 'created date' is captured the moment the user submits the form. When the request is processed and completed, the technician changes the request status to 'closed'(a drop down selection) and the record is saved. The form info is then moved to an archive sheet via automation (the Closed status change kicks this automation off).

How do I capture the date when the status gets changed to closed?

Basically, I am already capturing the date the form was submitted (created date) but would also like to record the date the technician actually finished the job (status changed to 'closed').

I am trying to measure and record average processing time.

Any advice would be appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!