Looking for help with Calculated Field on Request Custom Form

[JamesM-MERGE]

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 Asset Type=Letter), or the Asset Category selection that does not have any child asset type, or both. Currently, the field is functioning as expected but it's confusing.

I believe I need an IF statement, but I'm not sure how to write this. I would appreciate any help in making this work.

Asset Type Calc: CONCAT({DE:Print Asset Type},{DE:Web Asset Type})

Asset Type: CONCAT({DE:Asset Type Calc},{DE:Asset Cat Single Calc},{DE:Asset Cat Multi Calc})

I have the following sample fields and Request report:

[JamesM-MERGE]

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 - Single Select}="Print"&&{DE:Print Asset Type}="Statement Stuffer","Statement Stuffer",

IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Help Text/FAQs","Help Text/FAQs",

IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Marketing Page","Marketing Page",

IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Web Banner","Web Banner",

IF({DE:Asset Category - Single Select}="Logo","Logo"

))))))))

[MattHy]

I've got to admit this is blowing my mind a bit.  To clarify, are there two fields someone could use to request assets?  If they need one type, they use Single-Select & if they need multiple, the use Multi-Select?  Assuming yes, if Web or Print are chosen, then the requestor would see the Print asset or Web Asset type?  Are the Web Asset & Print Asset type single selects?

[JamesM-MERGE]

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("Statement Stuffer",{DE:Print Project Type},"Statement Stuffer, ","")

)))))

[JamesM-MERGE]

I tried to simplify further, and it's telling me "\"Letter\"" is not valid.

CONCAT(

IF(CONTAINS("Print",{DE:Project Category - Multi-Select})&&

("Letter",{DE:Print Project Type},"Letter, ","")

)))

[JamesM-MERGE]

I'm using this code from this Calculated field that shows multiple values from checkbox field post as a guide.

CONCAT(IF(CONTAINS("Swimlane Portfolio",{DE:AtApp Swimlane Tag}),"Portfolio | ",""),IF(CONTAINS("Swimlane Program",{DE:AtApp Swimlane Tag}),"Program | ",""),IF(CONTAINS("Swimlane Project Owner",{DE:AtApp Swimlane Tag}),"Project Owner | ",""),IF(CONTAINS("Swimlane Project",REPLACE({DE:AtApp Swimlane Tag},"Swimlane Project Owner","SwimlaneProjectOwner")),"Project | ",""))

@Doug_Den_Hoed__AtAppStore @Kiesner10  any chance either of you have any thoughts on how to make this work?

[JamesM-MERGE · Accepted solution]

I believe I've solved this.

CONCAT(IF(CONTAINS("Print",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Print",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("Letter",{DE:Asset Type Calc}),"Letter, ",""),

IF(CONTAINS("Print",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Print",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("Statement Stuffer",{DE:Asset Type Calc}),"Statement Stuffer, ",""),

IF(CONTAINS("Web",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Web",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("Marketing Page",{DE:Asset Type Calc}),"Marketing Page, ",""),

IF(CONTAINS("Web",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Web",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("Website Update",{DE:Asset Type Calc}),"Website Update, ",""),

IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("Employee Award Submission",{DE:Asset Type Calc}),"Employee Award Submission, ",""),

IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Multi-Select}),"",""),

IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Single Select}),"",""),

IF(CONTAINS("JD Power",{DE:Asset Type Calc}),"JD Power, ",""),

IF(CONTAINS("Logo",{DE:Asset Category - Multi-Select}),"Logo, ",""),

IF(CONTAINS("Logo",{DE:Asset Category - Single Select}),"Logo, ",""),

IF(CONTAINS("Corporate Giving Request",{DE:Asset Category - Multi-Select}),"Corporate Giving Request, ",""),

IF(CONTAINS("Corporate Giving Request",{DE:Asset Category - Single Select}),"Corporate Giving Request, ",""),

IF(CONTAINS("Event Material",{DE:Asset Category - Multi-Select}),"Event Material, ",""),

IF(CONTAINS("Event Material",{DE:Asset Category - Single Select}),"Event Material, ",""))