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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.