Smartsheet is truncating text when I export to Excel

walker35803

walker35803 ✭

11/08/21 in Smartsheet Basics

I have a column with a large amount of text in it (about 500 characters). When I export it to Excel, it truncates the column to 255 characters. Why? And how can I get it to export all the data in the field?

0 ·

Answers

Brett Wyrick ✭✭✭✭✭

11/08/21

Is it a formula?
Excel has a limit of 255 characters for formulas.

If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?

Help shape the future of Smartsheet.
Share your ideas and feature requests.