Index/Match formula not working
Hey community!
I've been using this Index/Match formula for a while now and suddenly, when I copy/paste it into a new sheet from my template sheet, I am getting an #INVALIDREF error. I didn't change anything and I have confirmed that it is pointing to the correct references so I don't know what is going wrong.
Is there anything that looks wrong about this formula?
Anything that might be causing it not to work suddenly?
=INDEX({SF Phase Mapper Range 2}, MATCH([Active Stage]@row, {SF Phase Mapper Range 1}, 0))
Thanks! and Tagging my formula guru @Paul Newcome for visibility!
Kelly
Best Answer
-
Hi @Kelly Gabel
I hope you're well and safe!
When you copy a so-called cross-sheet formula, you have to add the Sheet References to the new sheet manually, or it will not work.
Make sense?
Did that work/help?
I hope that helps!
Have a fantastic weekend & Happy New Year!
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 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.
Answers
-
Hi @Kelly Gabel
I hope you're well and safe!
When you copy a so-called cross-sheet formula, you have to add the Sheet References to the new sheet manually, or it will not work.
Make sense?
Did that work/help?
I hope that helps!
Have a fantastic weekend & Happy New Year!
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 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.
-
@Andrée Starå thanks! I had actually already done that and it still wasn't working which was why I was so confused!!
I ended up restarting my computer and it seems to be fixed now... LOL Must've been something weird in the cache.
Thanks so much!
Kelly
-
Glad you got it working!
Happy to help!
✅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.
-
@Kelly Gabel Haha. Thanks for the shout-out. It looks like it was just a bit of a gremlin though which fortunately worked itself out relatively quickly. Glad it is all sorted now.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!