the only problem with this is that I don't want it to display commas if only one field was selected. For instance with this formula if the first two fields weren't edited it would display as:  ,,VFX:name,Post:name.  I would want it to display as: VFX:name,Post:name.   essentially skipping the first ...

sure thing: CONCAT({DE:Comp:name},{DE:Lab:name},{DE:VFX 2:name},{DE:VFX:name},{DE:Post:name})

Hi All,I've created a concat formula that pulls in multiple typeahead fields.  What I'm trying to figure out is how to display a comma if more than one typeahead field has been filled out, but not to display a comma if there's only one field being populated.

Joaquin, I took your code and swapped out IF(ISBLANK with CONCAT and was finally able to get something to output.  Only issue now is if there are more than one field filled, how do I separate them with a "," or a "|"?

everything looks good.  I did a test to bring in one of my typeahead fields into a calculated  field to convert to text and it worked. there are about 12 typeahead fields that I was trying to bring in, and on each task form they are associated with, only 1 of the 12 will be filled out.  Is it possib...

I tried that but even when one of the typeahead fields is populating is still produces N/A in the calculated field. Should I concat the fields first before running a calculation? 

I cleaned it up a bit but it returns a value of N/A.

Hi All,  I'm trying to create a calculated field that uses IF(ISBLANK logic to only display the typeahead that has data entered (only one field will have data due to display logic in the form).  Example below: IF(ISBLANK({DE:typeahead field 1}.{name}),IF(ISBLANK({DE:typeahead field 2}.{name}),{DE:ty...

Hi All, I want to create a user report column that displays the last 10 or so projects the user has worked on. Has anyone attempted something like this before?

Hi All, I'm trying to figure out the easiest way to connect multiple user typeahead fields that live at a task level with a user object so that I can pull in multiple fields from the task to a user level report. Would appreciate any guidance on making these connections.