Smartsheet doesn't view known smartsheets im looking to reference?
Creating a reference sheet from one Smartsheet to another (looking to create a dashboard in future). However I am trying to vlookup or countif but it doesnt show a sheet that I full admin access. Trying to execute a simple step but cant find these sheets, iI have previously performed these tasks with other sheets.
Thank you in advance!
Morris
Best Answers
-
My suggestion would be to go to the sheet you want to reference itself, copy the name, then paste it in the search bar when doing your lookup.
-
You cannot create cross sheet references from a report. You can only reference sheets. Smartsheet won't even show a report as an option.
Answers
-
My suggestion would be to go to the sheet you want to reference itself, copy the name, then paste it in the search bar when doing your lookup.
-
Thank you. I thought it might be title or spelling errors previously. I tried again to make sure.
Another assumption is that i am trying to pull information from a "report" vs "sheet" that is the only other conclusion I can think of that may be blocking me? (Again I am an admin on all of these sheets/reports)
Thank you
-
You cannot create cross sheet references from a report. You can only reference sheets. Smartsheet won't even show a report as an option.
-
Thank you! Most Appreciated
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 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!