Has anyone else had VLOOKUPS start randomly throwing errors despite no changes made?

I've noticed since Thursday that on one of my sheets, the VLOOKUP will randomly throw an #INVALID ARGUMENT error despite the formula already working and having no aspect of it change. It seems to randomly do it sometimes when opening the sheet, but I've noticed that it creates an error every time if a new entry is submitted via dynamic view (bad, since that is the only way entries get added to the form). And it isn't just an error in the new row, The entire column of VLOOKUPS will be working properly, but the moment a new row is submitted they all throw an error.

Usually if I refresh the sheet it fixes itself, but this is getting annoying because I have a Generate PDF automation that is starting to create documents with errors. Sure, I can manually rerun it and make a V2 of the PDF, but as this sheet gets more and more entries that quickly will not be doable anymore.

And I am 100% sure it is not a formula issue (It's a very simple vlookup referencing a 2-column, 6-row sheet so there's no complexities to miss), I also heard that someone else at my organization is having the same issue with another sheet, so I don't think this is something as simple as an internet connection issue or a problem with my laptop specifically either.

I'm not sure what to do about this.

Find more posts tagged with

Sheets

Formulas

Dynamic View

Accepted answers

All comments

Diane Forbes

I am having the same issue. I'll be interested to see if anyone has any insight into this.

STK

I am also having a similar issue with a couple CountIFS formulas. They have been in place for weeks without any issues, and then last week several widgets on our Dashboards started erroring out.

I traced the issue down to an "Invalid Argument Set" within the widget's corresponding metric sheets, but as soon as I open any of the sheets, the errors go away and the Save icon is available…as if I have made a change, which I did not. If I click save and refresh, the Dashboard widget issue resolves…but it is happening a dozen or so times a day now, maybe more but I have no way to verify as the errors don't show up in the Activity logs.

While I am fairly new to Smartsheet, I have done my share of development over the years…and my gut says this a bug. Probably not a fair assessment, as I am a Newby and don't know what I don't know…but if it walks, talks, and quacks like a duck, … ;-)

Anyways, I created a support ticket today and have provided what they requested 🤞. I will follow this thread and update as I get more info 👍

Curious if anyone else has had\is having this issue…and when it started?

Thanks, Stephan

Georgie

Hi @claire409, @Diane Forbes and @STK,

Our support team has received multiple reports of this behaviour, and it's currently under investigation.

Thanks for your patience while they continue to investigate!

Georgie

Hi @claire409, @Diane Forbes and @STK,

Just an update to say that this issue has now been resolved and you should no longer be seeing the errors.

Thanks,

Georgie

Diane Forbes

@Georgie My issue is almost exactly the same as Stephan describes and it is not resolved at this point.

Georgie

Hi @Diane Forbes,

Sorry to hear you're still seeing the issue. I can confirm that our support team has now reopened their investigations into this issue.

Thanks again for your patience while it's being investigated!

Georgie

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.