Cross sheet formulas limitation

Corentin Dal Farra

Hello everyone,

Do you know if the cross sheet formula limitation in Smartsheet is for 100 references or for 100 different references ?

Because it could change everything if I can use one of my 100 references serval times in the same sheet.

Thank you very much,

Corentin

Ameya Athalye

@Corentin Dal Farra this is what they say in the documentation. See the before you begin section.

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Hope this helps.

Genevieve P.

Hi @Corentin Dal Farra

To clarify what the article means, 100 distinct references means 100 different ranges {in these}. So, you could have 100 cells with the same formula in them, all referencing {Range 1} and that would only be 1 reference, not 100.

There's a discussion on another Community post where we went over a similar question, see here.

Cheers!

Genevieve

Corentin Dal Farra

Hello @ameyaa and @Genevieve P

Thank you for your precisions on the subject !

Have a great day,

Corentin