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.




  • Jack Parry
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!