Smartsheet is truncating text when I export to Excel

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?

Answers

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭

    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!