How would I find how many references are being made to other sheets inside one sheet?

Jordan Myers

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.

Paul Newcome

If you right click on any cell and then select "Manage References", you should be able to find what you need there.

Jordan Myers

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.

Paul Newcome

If you right click on any cell and then select "Manage References", you should be able to find what you need there.

Jordan Myers

Great, thanks.

Paul Newcome

Happy to help. 👍️