Is it possible to add a new line in a Formula?

I found this discussion from 3 years ago:

It got a response from the community manager, so I would like to assume 3 years later it was implemented at some point

Is there a way I can do this?

Find more posts tagged with

Formulas

Hi Barnee,

Yes, it is! I'll get back to the post with a link to another post.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Here's one post.

Hope that helps!

Best,

Andrée

Brilliant - a bit overkill - but it works so no complaints here!! Thank you

Excellent!

Happy to help!

Best,

Andrée

@Andrée Starå adding carriage return?

Exactly what I need, but not working for me. If I understand this correctly I create a column and in the first row I enter "- (Enter) -"

When I actually press the 'Enter' key I am taken down to the next line.

Clearly I'm doing something wrong?

Using a date range to define a planned Sprint name
I want to use a Start Date to determine which sprint a ticket will be identified with. For example Sprint 17 starts on 08/13/25 and ends on 08/27/25. If my Start Date is within this range then I want to output the Sprint Name into a Planned Sprint column. =IF(([Start Date]@row >= "8/13/25", IF(AND)([Start Date]@row <=…
Question about automation to generate duration of each status
Can we get an automation to generate how long is the duration of the open, closed, and average days that each open status have been open for before a status changed? Also can we get an automated count of days that the item has been open or until the status changed to closed?
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…