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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Hello @ameyaa and @Genevieve P
Thank you for your precisions on the subject !
Have a great day,
Corentin
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives