Error message when trying to cell link

Sidonia Posteuca

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!

Darren Mullen

@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.