INDEX MATCH works then returns #NOMATCH upon saving the sheet.

BullandKhmer

OK, I'm really stuck on this one...

I've written a simple index match formula...

=INDEX({TSRCC}, MATCH([Unique Event+Session Date]@row, {TSR Event Name}, 0))

It worked perfectly fine. Then when I saved the sheet all rows changed to a #NOMATCH error.

When I rewrite the formula, it worked again, then when I went to save, it failed again #NOMATCH.

I'm so confused, any ideas?

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

Update, I've gone back into the sheet today and the formula works as intended. Would love to know whats going on here.

Any ideas anyone?

hollyconradsmith

Hi @BullandKhmer,

Are either the source sheet or the indexing sheet very large and have lots of formula fields? It could simply be a performance issue.

I would recommend reporting the issue to Smartsheet support: https://help.smartsheet.com/contact?fts=contact&_ga=2.116897414.1232551637.1643642854-725436069.1627560110

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.