Formula to automate a dashboard and reference previous / next cell
Hi,
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?
Answers

Are you wanting to put the formula in the grey row? Are the rest of the rows indented below the grey row so that they are "Child" rows?

Hi Paul,
I apologize for the late answer. I was OOF for few days.
To answer your questions:
 yes, I want the formula in the grey row. I currently manually update it each week
 What do you mean by child rows? The rows below the grey one are the weekly data used to calculate the % of change in the the grey row.
I hope that helps.

By child rows I mean are they indented so that they are nested under the gray row or are they at the same indentation level as the gray row?

Got it. They are at the same indentation level as the gray row. I can change it if that makes it easier to automate the formula.
Help Article Resources
Categories
Check out the Formula Handbook template!