Global update - cross sheet formula needed

Agata Wozniak
Agata Wozniak ✭✭✭✭
edited 09/20/24 in Add Ons and Integrations

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

Answers

  • NicoLHC
    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.

    If my comment helps you, I appreciate a 💡

    Kind regards

    Meet me at Engage in Seattle!

    Nico | LinkedIn

    CEO | Lighthouse Consultings

    Lecturer in Business Information Systems | DHBW

    ________________________________________________________________________________

    addvalue@lighthouseconsultings.com

    We offer Licenses - Training - Solution Engineering

    🔴Certified Smartsheet Partner _______________________________________________

    💯 SCALEABLE Solutions Engineered by Lighthouse Consultings

    We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.

    🎥 YouTube 🚀TimeLine View

    http://lighthouseconsultings.de/

  • Agata Wozniak
    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