Global update - cross sheet formula needed

Hi All,

While doing a global update I added new column ( type: Contact) I need to change the formula to that column.

The issue is the formula is cross sheet

=IF({Project Metadata (Do Not Edit) Range 3} <> "", {Project Metadata (Do Not Edit) Range 3})

it is meant to pull a an email address into the column from a different sheet.

(I tried it, and the formula works if applied manually, but I have over 50 sheets that need this column to run. With out that I cannot create filtered to current user reports)

How do I go about that? I initially just copy pasted the formula, but ofourse it flags up as InvalidReferrence.

I'll be very gratefull for all help tips!!

Find more posts tagged with

Formulas

global updates

Accepted answers

All comments

NicoLHC

@Agata Wozniak If you work with sheet references please name the reference otherwise this can cause issues especially if you work with multiple sheets and references.

Agata Wozniak

Hi @NicoLHC

Thank you for reaching out! can I just please check what you mean?

I usually add names to the reference, but in this case its 1 reference and the only formula in that sheet.

I can ofcourse re-name the "Project Metadata (Do Not Edit) Range 3" into "Metadata PM email address" but I am not sure if that will solve my problem.

Or am I lost completly?

Best,

Agata

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.