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.
Help Article Resources
Check out the Formula Handbook template!