How can I edit a formula reference across all projects using Global Update?

carlycrisp

I just did a global update to add two new columns to one of the sheets in my projects. Both columns included a vlookup. The columns came through fine, but the formulas aren't working because I used the reference "New Individual Rates Range 1" which already existed in my sheet. The original reference only evaluated the first three columns in the referenced sheet, but the new formulas need it to look at columns 4 and 5, as well. I'm wondering if there is a way to launch another global update to edit this reference so it will evaluate all five columns in the New Individual Rates sheet. That wouldn't mess up my pre-existing formula but would allow my two new columns to return the values I need.

Thanks in advance for your help!

Genevieve P.

Hi @carlycrisp

There currently isn't a way to push out a global update on a cross-sheet formula reference. Depending on what your previous formula looks like, you could potentially edit this one reference in that sheet to include the two new columns.

If your original formulas identify column 2 and column 3, etc, then tacking on more columns to the end of the reference shouldn't affect them. Using "Edit Reference" to update the one reference will push out this update across your whole sheet.

The alternative would be to manually delete the reference from the formula and input a new one.

See: Manage Sheet References

Cheers,

Genevieve