Formula to automate a dashboard and reference previous / next cell



I am trying to build a formula to remove a manual step in a report. I'd need some guidance on how to do.

In the screenshot below, I want to automate the % of change calculation. % of change = last week SLO - this week SLO. I think I can use the "Used in Dashboard?" column to build a formula but not really sure how to do.

Any thoughts?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!