Welcome!

Managing (deleting) cross sheet references

If sheet A contains 5 unique cross sheet references (each filled down through 1000 rows) in order to look up values on the master sheet and I delete all of the rows in sheet A, does that also delete (free up) those 5000 previously used cross sheet references? Thanks!

Find more posts tagged with

Comments

J. Craig Williams

There should be no impact unless you have crossed the 25k limit and then need to wait for the system to catch up.

But in my (limited) testing, yes.

Craig

Mike L.

Craig, thanks so much for your comments. I must say I seem to have a mental block about the 25K limit. Does this mean that you are limited to 25K inbound formulas? Or can you have more than 25K inbound formulas requesting data but only 25K cells in the reference sheet can have formulas pointing to them.

There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total,

Thanks, Mike

Sign in to join the conversation!

Quick Links

Trending discussions

Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
how can i overlap 2 tasks.
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Update Automations
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…