Formula to automate a dashboard and reference previous / next cell

Anne-Solene Monrouzeau

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?

Paul Newcome

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?

Anne-Solene Monrouzeau

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.

Paul Newcome

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?

Anne-Solene Monrouzeau

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.