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?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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.

    @Genevieve P. ?

    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)

  • Genevieve P.
    Genevieve P. Employee Admin

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!