Index Function Has Stopped Working

Options
RayR
RayR ✭✭
in Formulas and Functions

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!!

Tags:
· Share on FacebookShare on Twitter

Answers

  • Jack Parry
    Jack Parry ✭✭✭✭
    Options

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!