I am trying to replicate a formula, but it is changing all the formulas on the page

Tamar

I am trying to create the formula in the "Activities" row, to the "Issues/Pain points" row with a different reference column. I also need to change the reference sheet, but I want to get this formula right in the first instance.

Can anyone help?

Matt Johnson

Hi @Tamar

I think this is happening becuase you are editing a range that exists in the original location. Instead of editing the range in the new location, be sure to delete the entire range and then click in the place where it was in the formula. Then choose another range.

I hope that helps.

Matt

Matt Johnson

Hi @Tamar

I think this is happening becuase you are editing a range that exists in the original location. Instead of editing the range in the new location, be sure to delete the entire range and then click in the place where it was in the formula. Then choose another range.

I hope that helps.

Matt