Glitch in Smartsheets
We seem to be having some sort of glitch on some of our sheets where when we get a message that a change happened and then a second message comes in telling us that it resolved itself.
Below is what happened at 6:03 in the morning today:
Then 2 minutes later it reverts back to normal:
This happens at least once a month.
Is there a way to resolve this issue, so that we do not have this glitch?
Having this glitch tells our team in the field we received all this material all at once today and we can not have that confusion.
By the way, this happens on all our BOM sheets. It gets its data to populate from 1 sheet. So could it be coming from the source?
So any help would be appreciated.
Thanks!
Answers
-
Hi @ksandoval
Since this happens to all of your BOM sheets that are updated by 1 source sheet, yes, this could be caused by the source sheet. I've seen the #REF error occur when a sheet times out as it's loading data if the source or destinations sheets are getting quite complex - the formula needs extra time to calculate and process all that data.
Here's information on complex sheets: Issue: My sheet is slow to load
If this hasn't explained the behaviour you're seeing, I would recommend reaching out to Support with more information (such as the Sheet names / IDs, the source sheet, the formulas, how complex the main sheet is, when this first started happening, the last recorded time it happened etc).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!