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