Is there a way to clean up a formula with carriage returns or hard returns?

I'm trying to clean up a large nested "IF" formula so it is easier to understand. In Excel I can use ALT+ENTER to carriage return the text so it's easy to read. Basic formula protocol. I can't find anything in smartsheet forums stating how to do it, so I'm assuming it's either incredibly easy or doesn't exist. Currently it is a giant run on sentence and a pain to navigate.

Fingers crossed.



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Todd, I'm not aware of any way to do that within a formula. I copy complex formulas into Word and break them into pieces.


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • C Eiring
    C Eiring Employee
    edited 08/17/21

    This isn't exactly what you are looking for, but there is a way to put a carriage return in a formula. You can use CHAR(10). You need to have word wrap turned on for the column for this to work.

    You can take the = off the beginning of your formula, enclose it in double quotes and then insert carriage returns.


    ="Hello" + CHAR(10) + "World!"


  • + CHAR(10) + worked perfectly!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!