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.
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…
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.