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

Find more posts tagged with

Formulas

functionality

Comments

Mike Rini

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å

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!

Mike Rini

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.

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…