Add an Alt-Enter to a Formula?

MCorbin

I have a formula that is pulling a status update from 3 different sheets:

=IFERROR("BA: " + INDEX({ITBA Status}, MATCH($[Project / Task ID]@row, {ITBA PID}, 0)), "") + IFERROR(" AppDev: " + INDEX({Dev Status}, MATCH($[Project / Task ID]@row, {Dev PID1}, 0)), "") + IFERROR(" CS: " + INDEX({CSStatus}, MATCH($[Project / Task ID]@row, {CSPID}, 0)), "")

If it finds a match in the sheet, it should add it. The result is coming out like this:

BA: Complete AppDev: Complete CS: In Progress

I'd like it to look like:

BA: Complete

AppDev: Complete

CS: In Progress

Where it puts each status on a different line within the same cell. Can I embed an Alt-Enter into the formula? (and if so, how?)

THANKS!

Andrée Starå

Hi,

@MCorbin @L@123

You can use the CHAR function instead. (CHAR10 for line break)

https://help.smartsheet.com/function/char

Examples

CHAR(10) can be used to add a line break within a formula

="Apples" + CHAR(10) + "Oranges"

will display as follows:

Apples

Oranges

NOTE: To display a line break, you must use Wrap Text in that cell.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

L_123

I am not aware of a more advanced technique of doing this than what is mentioned in this comment:

https://community.smartsheet.com/discussion/6079/feature-request-join-carriage-return-separator

Andrée Starå

Hi,

@MCorbin @L@123

You can use the CHAR function instead. (CHAR10 for line break)

https://help.smartsheet.com/function/char

Examples

CHAR(10) can be used to add a line break within a formula

="Apples" + CHAR(10) + "Oranges"

will display as follows:

Apples

Oranges

NOTE: To display a line break, you must use Wrap Text in that cell.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

MCorbin

Thank you! Char(10) is definitely more efficient - and I'm saving that link for future reference :-)

Andrée Starå

Excellent! 

Happy to help! 

Martine Plante

For me, using JOIN and CHAR(10) works perfectly in the sheet but not in reports.

Any idea how to resolve this problem ?

Andrée Starå

@Martine Plante

Hi Martine,

The report should show the same as the sheet as long as you have the Wrap feature enabled.

Did that fix it?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Martine Plante

@Andrée Starå

It finally worked but took some time and a few updates.

Thanks a lot !

Martine Plante

Andrée Starå

@Martine Plante

Excellent!

Happy to help!

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!