VLOOKUP Lag In Updating
Hi all -
I'm connecting two sheets via a VLOOKUP to get a value (Status). I'm seeing a 2+ min lag in the delay in the update of the VLOOKUP - which I've never seen before. It's always been nearly automatic.
Even though there are only a few formulas, the VLOOKUP spans only two columns and there are only 50 or so rows, the lag seems to be a lot longer than what I've seen in the past.
Just to ensure it was not a function of something in the sheet, I built out a couple of test sheets, and tested the same functionality - but I'm still seeing the same issue in delay. I've also switched the lookups from VLOOKUP to INDEX(MATCH()) to see if that made an improvement, but no luck.
Any thoughts on why this seems to suddenly be taking longer? We had been using this previously, and it was near instantaneous, but now seems to be pretty delayed for no reason.
Any thoughts, suggestions or help would be appreciated.
Mike
Comments
-
I've been doing some testing, and the more I look into it, I don't think the formula has a delay, but rather the way I'm updating it.
We are changing a Status value from Sheet 1 and there is a VLOOKUP in Sheet 2 that gets that Status. When we change it, it's from a Report and that's where I see the delay - the relay from Report to Sheet 1 to Sheet 2. If I just go into Sheet 1 and change the status, it updates instantaneously.
Any ideas if there's a way to make that happen quicker?
-
Hi @Mike Rini
I hope you're well and safe!
That's strange because the Report is basically just another view of one or more sheets.
Have a fantastic week & 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, 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.
-
Hi @Andrée Starå agreed. The lag seems to be a bit better now (around a min), but still would like it to be more instant to eliminate confusion on the user end. The report has a parent-child relationship between two sheets, so when the parent status gets updated, the child does (via the VLOOKUP as well). Any advice you have other thoughts on how to approach show/hiding the child records in the Reporting View? I know how to make the parent row disappear, but it's the combo of the two that I'm struggling with. I can make the parent row disappear based on a filter, but I can't seem to make all of them move together as they should (i.e. - Parent + Child go to a new report based on filtering conditions)
-
Hi @Mike Rini
Reports were undergoing maintenance on January 10th which is likely why you were seeing a delay. Here's the documentation on this from the Smartsheet Status page.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 426 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!