carriage return between concatenated data

Options
LorieT
LorieT ✭✭
edited 04/12/21 in Smartsheet Basics

I am trying to create a concatenated cell with separate lines

Name

Date

Accomplishment


This is the formula i am using, but it is not inserting carriage returns

=Name@row + CHAR(10) + Date@row + CHAR(10) + Accomplishment@row

it puts everything on the same line with a space between them. what am i doing wrong?

Answers