#INVALID REF appeared some hours after Data Mesh was run, do you know the cause?
Best Answer
-
If you don't have any formulas, then it sounds like you may have set up Cell Linking in your configuration and this is where the error is coming from.
Yes, screen captures would be helpful to see your set-up and try to replicate the issue: it would be helpful to see your Workflow Configuration on each tab as well as the Source and Destination sheets.
However I would suggest working directly with Smartsheet Support on this so you can share a screen recording or screen share and share more sensitive information via a private channel.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
#INVALID REF is a formula error; it sounds like there may be a formula on your source sheet that you're pulling in to a second sheet, and it's this formula that is returning the error.
Can you identify what it is you're pulling through from Sheet A that is causing the error in Sheet B? Does the error appear in Sheet A as well, or only in Sheet B? Screen captures and the formula pasted would be helpful, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve,
Its is curious becase the data in the source sheet does not have a formula. So, the error only appeared in the sheet B ( target). Please let me know if the screen captures are still needed.
Thank you,
-
If you don't have any formulas, then it sounds like you may have set up Cell Linking in your configuration and this is where the error is coming from.
Yes, screen captures would be helpful to see your set-up and try to replicate the issue: it would be helpful to see your Workflow Configuration on each tab as well as the Source and Destination sheets.
However I would suggest working directly with Smartsheet Support on this so you can share a screen recording or screen share and share more sensitive information via a private channel.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives