Welcome!

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?

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?

Formula to check a box based on criteria
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
Distinct values from multiple sheets
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…