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


Hi all, 

I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. 

I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. 

Currently, I have a hidden