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

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

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

Mark Zamonski

Need global updates… I use a template for new projects which has a reference to the time tracking sheet which where I import time entries. every time we get a new employee, I have to add a column to the time tracking sheet and then update all the existing projects.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.