Yes, Web Asset Type and Print Asset Type fields are single select.This is my latest attempt to simplify:CONCAT(IF(CONTAINS("Print",{DE:Project Category - Multi-Select})&&IF(CONTAINS("Letter",{DE:Print Project Type},"Letter, ",""),IF(CONTAINS("Print",{DE:Project Category - Multi-Select})&&IF(CONTAINS...

This is now found under the 3-dots menu at the top of the selections. 

I've made some progress, but still not there yet. Any help is appreciated! CONCAT(IF({DE:Asset Category - Single Select}="Print"&&{DE:Print Asset Type}="Appetite Guide","Appetite Guide",IF({DE:Asset Category - Single Select}="Print"&&{DE:Print Asset Type}="Letter","Letter",IF({DE:Asset Category - Si...

I have a Request Custom Form that allows the user to identify if the Request is for a single asset or multiple assets. Some Asset Categories have an associated child Asset Type, other Asset Categories do not. I want the Asset Type field to pull in the specific child asset type selection (i.e. Print ...

Hi @JaimeDa can you share the syntax of how these two statements were strung together?I have a multi-select "Channel" field that I need to list out on a report all the various options selected. 

I'm looking for help with text mode calculation between Project Actual Start Date and Task Actual Completion Date on a Task report.

Final result   Final text mode: aggregator.displayformat=compound aggregator.function=SUM aggregator.namekey=datevariance aggregator.valueexpression=CONCAT(ROUND(DIV(WORKMINUTESDIFF({actualStartDate},{actualCompletionDate}),480),0)," Days") aggregator.valueformat=asString description=Total Task Hou...

I found some another article that helped me solve this. However, it doesn't include the "Days" label now. https://experienceleaguecommunities.adobe.com/t5/workfront-questions/exclude-weekends/m-p/573644#M51778     My (nearly) final text mode: valueexpression=ROUND(DIV(WORKMINUTESDIFF({actualStartDa...

Thanks Heather! I tried both and I'm still getting the same result.  

I'm trying to display the Actual Duration on a Task report in whole numbers of days. My text mode below is including the first decimal. Any help is appreciated!   aggregator.displayformat=minutesAsDaysStringaggregator.function=SUMaggregator.namekey=actualdurationaggregator.valuefield=actualDurationM...