Error message when trying to cell link
I have created a comprehensive report where I am trying to cell link information from 5 different sheets. I am getting this error message..
Is there a limit to how man cell links you can have? Is it because I am using the cell link in a formula? I have a lot more referencing to do and I am getting this message.
Please help!
Answers
-
@Sidonia Posteuca yes, 100 distinct cross-sheet references is the limit: https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas#:~:text=A%20sheet%20can%20include%20no,maximum%20of%20100%2C000%20inbound%20cells.
Before you create cross sheet references
Ready to work with cross-sheet formulas? Keep these things in mind:
- You must have the required permissions. See the chart below.
- A sheet can include no more than 100 distinct cross-sheet references.
- A reference range can include a maximum of 100,000 inbound cells.
- 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.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!