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!