Concatenate "DateTime" with "Reference" Text

Ask for Help
1

Hi folks!

How do I concatenate a DateTime column together with a Reference column to another table, with a Text Column. There is any way?

Thanks in advance!

1 Like
2

Hi Eduardo!

I made an example here: Concatenate Date + Ref + Text

You an use the format() function to format the different column types as a string. The formatting is between the "quotes". The empty squiggly bracket {} are placeholders for the columns in the function. The columns apply to the {} respectively.

2 Likes
3

Work Perfectly! Thanks!

4

I cannot read the formula column. It is grayed out. When I download as a CSV the formula is removed. Can you add the formula in another column so we can see your example? Or how am I able to view the formula you did? Concatenate Date + Ref + Text - Grist

https://tinyurl.com/2kzjogcb

Thank you

5

Hi Jennifer!

The formula is:

"{} - {} - {}".format($Date, $Ref.Text, $Text)

Here is a link to open the same document in Fiddle Mode. You’ll be able to double click and view/edit/copy the formula from this link.

https://public.getgrist.com/uDYwLSde5gYX/Concatenate-Date-Ref-Text/m/fork

Thanks,
Natalie

1 Like
6

Perfect, thank you very much!