Extract Cell History For Formulas

bhope51 ✭✭✭
edited 12/09/19 in Formulas and Functions


Is there any way to extract the Cell history to calculate formulas.

What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time spent between the changes.

Thank you.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!