Is there a formula that can capture the date when a cell changes?

Options

I have a list of dropdown categories to capture the project stage and would like to capture the date when the project stage changes. I also have a list of dropdown categories with the project stage owners that I would like to capture the date of when this changes. My goal is to see how long the project takes on each stage and in who's ownership the stages are. Is there a formula available where I can capture this information?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!