Increase cell character count

Kirsten George

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?

Paul Newcome

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.

aaroncole

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 :)

joelsmit94161

@Kirsten George Perhaps I am misunderstanding your needs but, couldn't you use the comments field to store some of your information?

Kirsten George

@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.

KPH

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. 😕