Advanced Calculated fields: Concat behavior

[TH7]

When concatentating fields in an advanced formula, there is no way to include a space between the fields.

This includes wrapping the property in quotes and adding a space afterwards:

Here is the result on record:

As well as using tokenization curly braces:

Result on the record:

In fact, the formula appears to remove whitespace:

I tested this by putting a space after the label:

This could be a cool little function, if we were allowed to control how it looks. I’m not looking for camel case. I just want to reduce the number of workflows I need to segment data.

Being able to use more than 2 strings, and/or pull out substrings would be nice too.

Thank you!

[TH7]

UPDATE: Saw today that this has been fixed. We can now concatenate up to N values.

Fixed Concat

Additonally, we can combine concatenate with some powerful functions.

For example,

concatenate(number_to_string( year([properties.createdate])),“-”,number_to_string( month([properties.createdate])))

I was able to create a custom formatting for my create date property. This was a request made to enable easier reporting in spreadsheets: