Global update - cross sheet formula needed

Agata Wozniak

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!!

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