Cross sheet references

Mihai Nedelcu

Hi,

Is really the number of cross sheet references limited to 100? I have a summary sheet where I make references to other projects and it seems 100 is the limit.

Is this for real?

Stefan

Hi @Mihai Nedelcu,

yes:

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

You may be able to work around that limitation, depending on the structure of your source sheets and what you pull from those sheets.

My example: I once did a sheet with one column per calendar week (52) that pulled data from another sheet with people from 24+ departments (ca. 60 persons) so using individual references was no option due to the limit.

I made it work with some additional columns in the pulling sheet and a formula construction, that only needed an individual reference for each week.

Hope this helps

Stefan

jwmcintyre

@Stefan what was the work around you used?