Where is referenced field
Ok, first, I took over this sheet, report, dashboard from a former employee and out of nowhere a sheet stopped working. I know the problem, just trying to determine how this happened and how I can fix it.
There is a cell with a formula. The formula references a field in some other sheet. How can I determine where it is?
If i just click on the reference in the formula, it opens the formula popup and allow me to click on Reference Another Sheet and I have to select something. Nothing is highlighted as if it already knows where it is currently referencing.
This leads me to believe someone may have removed some dependency for this formula. I need to find out where or what that is/was.
Is there a way to see this?
Comments
-
Hi Pam,
Can you describe your process in more detail and maybe share the sheet(s) or some more screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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 and thanks for your reply. I had an awakening and realized the referenced field was a cell (column) in that same worksheet. I believe the formula got accidentally removed from the sheet whereas in another similar sheet it was there. All is working as it should.
Thank you.
-
Excellent!
Happy to help!
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.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!