Calculated field with if..then, not returning as expected

[HeatherSc2]

Hi, I thought I had this calculated expression written correctly, but everything returns "Other".  Have I missed some syntax somewhere or should I be using a different expression.

IFIN({DE:*PRM Project Type}, "Adhoc", "Funded- Signature", "Funded-P&P","Funded-A&E","Conferences/Events/Webinars", "Funded (Signature)", "Japan","QUANT Client/Member","Research Circle", CONCAT("Primary Research"),IFIN({DE:*PRM Project Type},"Gartner Benchmark","Gartner Score","QUANT Benchmarks & Diagnostics", CONCAT("Benchmark & Diagnostics"),CONCAT("Other")))

The *PRM project type field is a single select dropdown and we do have 'show values' on.  I wasn't sure if that was causing an issue.

You can see that it always calculates to 'Other'

Thank you!

[Sven-iX · Accepted solution]

I think you need to use the VALUE - not the label in the expression

Meaning "Adhoc" is the label, and "A" is the value

[HeatherSc2]

I was wondering that.  Let me try that and see.