Help

Converting Multiple Fields into Text Field

Topic Labels: Base design Formulas
1110 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan_McMahon
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

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")

Screenshot 2023-03-01 at 5.21.06 PM.png



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