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

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

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