Cross sheet Index Match suddenly not working
Hi guys, Hopefully someone can give me some help on this.
I have set up many cross sheet index matches that have worked without any issues for 1-2 years. I logged in to Smartsheet recently to find some cells now returning REF#. The formula is correct, but I re wrote / re linked the formula to see if it would fix the issue. At first attempt it did fix it, however the next time I logged in it had broken again. Now when I log in all of my referenced cells have broken.
Smartsheet have told me that this means the referenced cell has been deleted, which isn't the case.
Has anyone else had this problem?
Answers
-
I hope you're well and safe!
This might be the reason for the issue.
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks @Andrée Starå
Interestingly Smartsheet didnt offer me this information, instead telling me I must have deleted a column.
I am using a third party called ddupdate on my sheet. Do you know if this is a known could be causing the issue?
-
Update! I managed to fix the issue by deleting the broken references from within reference manager and re mapping
-
Excellent!
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!