Skip to main content

Hi all, 

I am looking to create a field that will automatically create a string from multiple sources.

I am looking to create a bar schedule and I've found that the Gannt view is best for this as it allows me to export as a PDF. My issue is that I'd like it to include more info in the description. Essentially I want the record's name, the start and the end date included. I was wondering if there is a formula that could automate this for me.

You should be able to accomplish this with `CONCATENATE()` or `{Field 1} & " " & {Field 2}` etc.

Given that you're also using start and end dates, you'll probably need to look into `DATETIME_FORMAT()` as well

For example, in the screenshot below I used the following formula:

Name & " - " & DATETIME_FORMAT(Date, "DD MMM YYYY")



I recommend checking out the formula field reference and experimenting with what I've mentioned above!


Reply