How would I find how many references are being made to other sheets inside one sheet?
Thanks in advance for any answers. I am using smartsheets as an estimator currently and one thing I was worried I would have to deal with was the reference limit. I keep getting the "Incorrect Argument Set" error, even though I am just copying and pasting rows. I think it is the reference limit because it has not done this until now. Is there a way to find out how many references are being made, like in a file description, without having to manually do the math based on rows and columns?
I have 4 columns designated for referencing other cells and about 550 rows inside those columns doing the referencing. Some of those columns have multiple references in each cell, which is why I want to avoid doing it manually.
Best Answer
-
If you right click on any cell and then select "Manage References", you should be able to find what you need there.
Answers
-
Not sure why it broke in the first place, but now it is working again. It would still be useful to know if there is a quick way to check your number of outbound references.
Thanks.
-
If you right click on any cell and then select "Manage References", you should be able to find what you need there.
-
Great, thanks.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives