Cross sheet formulas limitation
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
Answers
-
@Corentin Dal Farra this is what they say in the documentation. See the before you begin section.
Hope this helps.
-
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
-
Hello @ameyaa and @Genevieve P
Thank you for your precisions on the subject !
Have a great day,
Corentin