I use Smartsheet to document contract compliance. Sometimes compliance actions can take up to 2 years and I exceed the 4,000 characters in an excel cell. Is there a way to increase the # of characters in a cell?
Sign in to see the current vote count, add your own vote, or leave a comment.
There currently is no way to increase the limit, but I have run into a few instances where it would have been really nice to be able to have more than 4,000 characters. I'm adding my vote.
I just had to abandon a really cool use of Document Builder because one of the fields was going to exceed the character limit. I've ended up replacing it all with a file upload field, but I'm super bummed.
You've got my vote :)
@Kirsten George Perhaps I am misunderstanding your needs but, couldn't you use the comments field to store some of your information?
@joelsmit94161 - I need to be able to download the compliance action information into reports to send to various regulatory departments, lawyers, etc, so the comments field would not work unfortunately.
I have a formula in an accounting sheet that only just sneaks in under the 4000 limit because I changed all my column names and made my cross sheet references 2-3 digit codes rather than something meaningful. The formula is used to calculate revenue per quarter using contract start, duration, price, renewal duration, renewal price, re-renewal duration, re-renewal price, etc. Same formula in 80 different columns using the first row of the column to identify the quarter. We cannot split this formula into 2 columns as adding another 80 and hiding them every time we need to unhide another column in this large sheet isn't viable. At the end of 2025 this formula will no longer work. 😕
Adding that I work for a book publishing company that just transitioned from Excel to Smartsheet for our book production data and we keep track of the entire history of book in one notes column. The project history notes for every book definitely exceed more than 4000 characters each and I am still looking for a workaround for this!
The 4,000 character limit per cell in Smartsheet is very restrictive. Excel has more than 32,000 and Google sheet is 50,000. Please can you increase Smartsheet cell character limit to 50,000? Thanks!
4000 characters is very restrictive for staff as they are entering updates, some of which require much more space than 4000 characters.
I've mentioned this before, but I have a formula that was more than 4,000 characters. I shortened column names to make it work. At the end of this calendar year, I will need to include two new columns in that formula and there is no way to do it with the current character limit.
I am using summary fields to aid in reporting data. Some of those summary fields happen to be lists of data. It would be EXTREMELY helpful to have more than 4,000 characters in a field, especially for summary fields.
I think something to also keep in mind here is that certain functions for formulas will only evaluate up to 4,000 characters at a time. Increasing the cell character limit means we should also mirror that in all of the various functions as well.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
