Trying to calculate a change over time, but ignore missing data

Formula: =IFERROR(ABS([2012]@row - [2023]@row) / MAX([2012]@row:[2023]@row), "")

but the formula returns a 100% if the first column data is missing. If the last column data is missing, the % change is skewed lower.

The data is not restricted or proprietary. it is new construction cost by zip code over time.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!