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!!
Answers
-
@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
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe 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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives