Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula for a carriage return within a cell
i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column.
="Milestone Count. . . . . . . " + COUNT([Notify Finance]21:[Notify Finance]74) + " Milestone Reached. . . . . . . . " + COUNTIF([Notify Finance]21:[Notify Finance]74, "Yes") + " Milestones To Go. . . . . . . . " + COUNTIF([Notify Finance]21:[Notify Finance]74, "No")
Is there a way to add a carriage return? I've tried multiple spacing but it doesnt work.
Any help will be fantastic.