Remove or Increase Cross Sheet Reference Limitations
Comments
-
Please Remove Cross-Sheet Reference Limit.
-
@Paul Newcome that sounds like a solution that could work for me as well, can you please give me an example, I get that I add an extra row, but please unpack the parsing solution
-
@Roxanne There are a number of different ways to parse in Smartsheet in other threads. The right one for you depends on exactly how your string is created. My personal preference when I have total control over all of the variables is to use different characters as delimiters that wouldn't be found anywhere in the strings. I like to use the UNICHAR function because I can use a set of numbers within the function to output unique delimiters but also keep the delimiters in numerical order to make adjusting formulas easier. Since the helper column can be hidden after setting it up, it doesn't really matter what it looks like as long as it is functional.
=UNICHAR(8600) + [1st Column]@row + UNICHAR(8601) + [2nd Column]@row + UNICHAR(8602) + [3rd Column]@row + UNNICHAR(8603)
Once you bring this string over, you can use a formula to parse things out as needed.
=MID([Helper Column]@row, FIND(UNICHAR(8600), [Helper Column]@row) + 1, FIND(UNICHAR(8601), [Helper Column]@row) - (FIND(UNICHAR(8600), [Helper Column]@row) + 1))
=MID([Helper Column]@row, FIND(delimiter for start of piece you want to grab from string, [Helper Column]@row) + 1, FIND(delimiter for end of piece you want to grab from string, [Helper Column]@row) - (FIND(delimiter for start of piece you want to grab from string, [Helper Column]@row) + 1))
-
@Bob Fraser is there any update on when the cross sheet reference limit will be increased from 100?
-
As user I would like to be able to at least have 200 distinct cross-sheet references
-
Increase the 100-reference limit for cross-sheet references in Smartsheet to 10,000 or more. It will make it possible to mine and process more information from more sources, in one place (sheet). For example, in a portfolio of 50+ project plans at one time, it would be great to be able to mine each for its last completed task (and date), and its next-up task. Right now, this takes equations with at least five references per plan. For 50 plans, that means 250 cross-reference sources on one sheet. If project managers want to track this info for years to come, it could easily exceed thousands of references during a PM's tenure in the role.
-
I have had similar issues with the 100-reference limit for cross-sheet references while compiling information for KPI purposes
-
@Archemoros Your particular example can be accomplished using Control Center.
