Unable to create cross-sheet references

lcamacho19911

The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" .  How many references we can do?  I am using a sheet that has information of 13 sheets combine. (like a summary sheet).  I like the summary sheet but the information in listing down and in my case I need it in a grid sheet.

Luis from PR

Andrée Starå

Hi Luis,

 

You can have 100 distinct - cross-sheet references.

More info: https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas

Before You Begin

Here are some things to keep in mind as you work with cross-sheet formulas:

• All the data in the range being referenced is available and potentially visible in the destination sheet, meaning you shouldn’t include any data in the reference that you don’t want available in the destination sheet.
• Each sheet can include no more than 100 distinct cross-sheet references. 
• There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.
• When you create a reference to another sheet, you can only reference data from a single sheet. If you need to reference data from multiple sheets, you’ll need to create multiple references using the steps below
• The following functions don’t support references from another sheet: CHILDREN, PARENT, ANCESTORS. Using a reference from another sheet with these functions will result in an #UNSUPPORTED CROSS-SHEET FORMULA error in the cell containing the formula. For more information on this and other formula errors, see Formula Error Messages.

 

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sam Hilsman

This is the most ridiculous limitation possible.

I just spent over 6 hours creating a massive dashboard for an extremely important project, and have run into the 100 cross-sheet references limitation with the need to create 8 more.

I cannot believe they tell you that the best practice in their system is to create a metric sheet for a dashboard and them limit you to 100 cross-sheet references. If this is not fixed ASAP then this product is essentially unusable for any enterprise level projects.

Chris Shifflett

Sam,

I completely agree with you and your frustration. I build at an enterprise level as well and this limitation is forcing me to look for other solutions. Smartsheet has a lot of features, but still very elementary IMO.

Thanks!

DWise

https://community.smartsheet.com/discussion/comment/266430#Comment_266430

I often hit this limit ... here's my work-around:

1. Run your Charts & Metrics Sheet up to the limit of 100.
2. Save as New, multiple times.
3. Parse things out into smaller chunks.
4. Store collection of newly created Charts & Metric sheets in a Charts & Metrics folder.

Albeit, a pain if you're not planning for this from the beginning!