Cross-sheet formulas can't be updated
Hi all,
We have a sheet that references a lot of data on other sheets using index and match functions. Recently, we began receiving the below notice and many cells in the sheet come up as "#calculating."
What do you propose as a workaround to this issue? Thank you in advance
Answers
-
I hope you're well and safe!
I would need to have more information to give a better recommendation, but one thing you could potentially do is to combine multiple columns to one and then break them out in the destination sheet(s) instead.
I recently did this in a client solution with a huge and advanced price list.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
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.
-
Thank you for the response, Andree! To elaborate further, we have referrals that are logged in a main sheet. When some of those referrals reach a final status (non-admit, discharge, etc.) they transition to a finalized sheet on a weekly basis (every Friday night). The destination sheet in question is specifically for one vendor to keep abreast of their referrals. The fields for each referral are brought in to the destination sheet through column formulas (example: =IFERROR(INDEX({Intake Tracking Range 1}, MATCH(EPIID@row, {Intake Tracking Range 2}, 0)), INDEX({Intake Tracking - Finalized Cases Range 1}, MATCH(EPIID@row, {Intake Tracking - Finalized Cases Range 2}, 0))) There is too much data on the two source sheets to which the destination sheet refers.
Hope this clarifies things a bit. Can you please elaborate on how we would combine multiple columns into one and them break them out?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!