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
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.
-
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives