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 find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…