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.
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
