Function Keeps Breaking

Hello - I am doing the INDEX + Match functions and it works for a day or two then it breaks again. Am I doing something wrong?

I am the owner of the current sheet and pulling data from a sheet that I do not own but I am the admin on.


Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Sarah Underwood ,

    Is someone else making changes to the base sheet that impact your data ranges? From within your formula highlight a portion of the range until you see the option "Edit Reference" and click it. Is it the right range? Not sure what else could be going on.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Hi @Mark Cronk - when I update it the range is correct. But yes, it is being updated on the other sheet and my plan is to pull all the updated data through to my sheet. So when the data is updated on the other sheet the function no longer works.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!