Cell link 5,000 limit, when will this end?

jb@59069 ✭✭✭✭✭✭

03/05/20 in Formulas and Functions

Yet again I have hit the limit on linking cells between sheets. When will this be addressed?

I keep having to create more and more and more sheets yet keep running into this wall.

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Formula need to return Pass/Fail if 1 of multiple cells are blank
Hi, I am trying to put a formula together that will provide a fail if any part of the address or the phone number hasn't been provided. The below formula only provides fail if all cells are blank. I have tried other variations, this is the only one that does not give me some sort of error. =IF(OR(NOT(ISBLANK([Street…
Combining AVG/COLLECT/NETWORKDAYS
I am attempting to calculate the average number of working days it takes to complete a request, Criteria I want to base the data collection on include: urgency level Month and Year(I created a rolling month chart to see trends-see below screenshot) The Work Completion Date determines the month it will be reported on This…
CountIf Function
I want to count the number of each option in this example; Change Router, Upgrade, Disconnect. My Objective column is set up as a drop down with allow multiple values enabled. My formula is only calculating Row 5, because that is the only row with only one value. How do I get my formula to calculate each drop down option…