view exact range in cross sheet reference
Hi All,
How can I see in a formula created by someone else what are the exact cells included in the range in cross sheet reference? I managed so far to identify the reference sheet, however in the edit reference range window it does not show what is the range used as of now.
Thanks!
Answers
-
I hope you're well and safe!
Try accessing it again because sometimes it doesn't show the first time.
Did that work/help?
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, Awesome, 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.
-
Hello @Andrée Starå !
Thank for the reply. I have tried by now several times, and it doesn`t look to be working. Maybe I don`t know what to exactly look at, I am not sure... Could you share, by any chance, a print screen which works for you? Maybe this could help me...
Thanks!
-
@Melinda Tempfli Do you have full access to the referenced sheet? Have you scrolled completely side to side to look for the column? That should reveal the selected range.
dm
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!