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

Todd Remter

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.

Todd

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.

Mark

C Eiring

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.

Example

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

Hello
World!

rcbitt

+ CHAR(10) + worked perfectly!!!