Capture the date in the cell when it is populated

Vivien Chong
Vivien Chong ✭✭✭✭✭✭
edited 04/09/20 in Formulas and Functions

If I would like to capture the date of a cell when an update is made, is there any way to do so without using 3rd party integration?

Cannot use modified date by system as there will be more updating of data in that row.

I understand that we can always put another date column to manually input the date, but just trying to find if it can be automated, as there are many dates to be captured in a row for KPI calculation purpose.

2 scenarios:

1) I want to capture a particular update date. Is there a way to do so?

2) If I just want to capture the date when the status show "completed", is there a way to do so?

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!