Hi - is there any way to get rid of inbound cells limitation when using formulas? Or any plan to remove it as it is so restrictive to do just some basic calculations cross sheets? Thank you
Hello @Martin Suchy ,
If possible, are you able to show the Formula you are currently using for Cross Sheet references?
If you are currently using a VLOOKUP Formula, you will want to switch this to an INDEX/MATCH if you are cross referencing a mass of data.
INDEX/MATCH Formulas perform better as they are able to look for more accurate results where as VLOOKUP Formulas look across an entire table.
You may also wish to reach out to our Support Team for if this error is persistent: https://www.smartsheet.com/contact
Let me know if you have any questions!
Hi @Sean Morgan,
I am using Index/Match combination to get desired data from other 4 sheets into the key one. Those 4 sheets are pretty huge thus I am having troubles to load all I need but there is no way to cut it in any way, rather the opposite.
Does it mean that support team can help eg changing limitation?
Hi @Martin Suchy
As @Sean Morgan ask you before, could you please show the Formula you are currently using for Cross Sheet references, and could you supply a screenshot ( remove any sensitive data ) so we can help you with some ideas to solve your problem.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.