Index Function Has Stopped Working

Has anyone else experienced this as of 2/19/24? In Control Center, many of my sheets that use Index have suddenly had the formula fail to work. These are sheets where they were previously working with no problem.

Troubleshooting eliminated the idea the problem was with Match (correctly returns the row index), but even when I simplify the equation to ONLY Index, it gets a NO Match error. This ONLY began on 2/19.

HELP!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jack Parry

I have the same issue! The problem is apparently I have too much data in my sheets, so the calculations are returning as blank, but only started seeing this being an issue in the last 2/3 weeks.

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.