Cross-sheet reference maximum?

laura.sandoval

Hello! I received an error when I was working on one of my sheets that says:

"Unable to create cross-sheet reference, because this sheet already contains the maximum umber of different cross-sheet references."

This is the first time I've see it, the sheet it happened on is a dashboard metrics sheet that pulls from several different sheets different values. Is there a limit I didn't know about? What can I do to work around this?

For context, the sheet of metrics has a list of all the clinics we have (48) and each has two values that we're pulling with a formula (=value and =countif) from it's respective sheet.

KPH

Hi

The limit is 100. So if you have 48x2 you would be very close to that limit. You may have a couple that you are not using (right click and select Manage References). Deleting those that aren't in use could unblock things for now but won't allow any wiggle room to add any more data or clinics in the future.

https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas#:~:text=A%20sheet%20can%20include%20no,100%20distinct%20cross%2Dsheet%20references.