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?

Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
Formula error - Incorrect argument set
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…