Formulas Not Working: Who did it?
![BESP10](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Good afternoon, we have a master sheet where we have columns that are based on formulas from other columns and someone changed something. They say they did not do anything but 16,000 cells changed.....how do we get down to what they did to make this happen? We need to get these back to working again.
Thank you
Best Answer
-
Have you checked the cross sheet references? It seems like one or more isn't working.
Was that the issue?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @BESP10
I hope you're well and safe!
Have you checked the Activity Log for clues?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå it says he changed 16,000 " but how can I find out what he physically did that prompted these all to change? thank you
-
The person listed in the activity log may not have changed anything, the might have just triggered the sheet to update by opening it.
What's the Error message and formula in your HTD column?
-
HI @Paul H , here is the formula
=SUMIFS({BES2022DailyWorkHrLog_HRSTODAY}, {BES2022DailyWorkHrLog_SSProject#}, [SS Project #]@row) + SUMIFS({BES2021DailyWorkHrLog_HRSTODAY}, {BES2021DailyWorkHrLog_SSProject#}, [SS Project #]@row)
it is reading as #invaid REF
how do I figure out what happened?
-
@besp10
I see you added another screenshot right before I answered, its possibly a broken cross reference in your HTD column
Right click on a cell and go to Manage References
-
Have you checked the cross sheet references? It seems like one or more isn't working.
Was that the issue?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!