Index Match References Disappearing

Sarah_lee123
Sarah_lee123 ✭✭
edited 08/06/22 in Formulas and Functions

I am experiencing glitchiness around programmed index match references disappearing. The sheets I have linked will function fine for a period of time and then we will notice the data begins to simply not populate in the receiving sheet. When I look at the index match reference, its gone and I have to remap it. Our formula is correct, , but when I click on the formula to check the sheet reference, it either gives me a blank slate asking me what sheet and columm I am trying to reference (even though it should already remember this information). or it has a different sheet selected and I need to corect it. The formula columns are locked to the users, and we are all on chrome browsers. This is happening at an exhausting rate and I can't figure it out. Any input is appreciated.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!