Forum Discussion
MarkShnier__You
Qrew Champion
try this
If([Customer Type]= "Corporate Coalition",
Case([Project Type Rollup],
"Audits", "Corporate Coalition-Audits",
"Consulting", "Corporate Coalition-Consulting",
"Desk Research", "Corporate Coalition-Desk Research",
"Guidebook", "Corporate Coalition-Guidebook",
"Training", "Corporate Coalition-Training",
"CUMULUS", "Corporate Coalition-CUMULUS",
"Other", "Corporate Coalition-Other"),
[Customer Type] = "Foundation",
Case([Project Type Rollup],
"Audits", "Foundation-Audits",
"Consulting", "Foundation-Consulting",
"Desk Research", "Foundation-Desk Research",
"Guidebook", "Foundation-Guidebook",
"Training", "Foundation-Training",
"CUMULUS", "Foundation-CUMULUS",
"Other", "Foundation-Other"),
[Customer Type] = "Government",
Case([Project Type Rollup],
"Audits", "Government-Audits",
"Consulting", "Government-Consulting",
"Desk Research", "Government-Desk Research",
"Guidebook", "Government-Guidebook",
"Training", "Government-Training",
"CUMULUS", "Government-CUMULUS",
"Other", "Government-Other"),
[Customer Type] = "Large Business",
Case([Project Type Rollup],
"Audits", "Large Business-Audits",
"Consulting", "Large Business-Consulting",
"Desk Research", "Large Business-Desk Research",
"Guidebook", "Large Business-Guidebook",
"Training", "Large Business-Training",
"CUMULUS", "Large Business-CUMULUS",
"Other", "Large Business-Other"),
[Customer Type] = "Small Business",
Case([Project Type Rollup],
"Audits", "Small Business-Audits",
"Consulting", "Small Business-Consulting",
"Desk Research", "Small Business-Desk Research",
"Guidebook", "Small Business-Guidebook",
"Training", "Small Business-Training",
"CUMULUS", "Small Business-CUMULUS",
"Other", "Small Business-Other"),
[Customer Type] = "NGO/Non-Profit",
Case([Project Type Rollup],
"Audits", "NGO/Non-Profit-Audits",
"Consulting", "NGO/Non-Profit-Consulting",
"Desk Research", "NGO/Non-Profit-Desk Research",
"Guidebook", "NGO/Non-Profit-Guidebook",
"Training", "NGO/Non-Profit-Training",
"CUMULUS", "NGO/Non-Profit-CUMULUS",
"Other", "NGO/Non-Profit-Other"))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If([Customer Type]= "Corporate Coalition",
Case([Project Type Rollup],
"Audits", "Corporate Coalition-Audits",
"Consulting", "Corporate Coalition-Consulting",
"Desk Research", "Corporate Coalition-Desk Research",
"Guidebook", "Corporate Coalition-Guidebook",
"Training", "Corporate Coalition-Training",
"CUMULUS", "Corporate Coalition-CUMULUS",
"Other", "Corporate Coalition-Other"),
[Customer Type] = "Foundation",
Case([Project Type Rollup],
"Audits", "Foundation-Audits",
"Consulting", "Foundation-Consulting",
"Desk Research", "Foundation-Desk Research",
"Guidebook", "Foundation-Guidebook",
"Training", "Foundation-Training",
"CUMULUS", "Foundation-CUMULUS",
"Other", "Foundation-Other"),
[Customer Type] = "Government",
Case([Project Type Rollup],
"Audits", "Government-Audits",
"Consulting", "Government-Consulting",
"Desk Research", "Government-Desk Research",
"Guidebook", "Government-Guidebook",
"Training", "Government-Training",
"CUMULUS", "Government-CUMULUS",
"Other", "Government-Other"),
[Customer Type] = "Large Business",
Case([Project Type Rollup],
"Audits", "Large Business-Audits",
"Consulting", "Large Business-Consulting",
"Desk Research", "Large Business-Desk Research",
"Guidebook", "Large Business-Guidebook",
"Training", "Large Business-Training",
"CUMULUS", "Large Business-CUMULUS",
"Other", "Large Business-Other"),
[Customer Type] = "Small Business",
Case([Project Type Rollup],
"Audits", "Small Business-Audits",
"Consulting", "Small Business-Consulting",
"Desk Research", "Small Business-Desk Research",
"Guidebook", "Small Business-Guidebook",
"Training", "Small Business-Training",
"CUMULUS", "Small Business-CUMULUS",
"Other", "Small Business-Other"),
[Customer Type] = "NGO/Non-Profit",
Case([Project Type Rollup],
"Audits", "NGO/Non-Profit-Audits",
"Consulting", "NGO/Non-Profit-Consulting",
"Desk Research", "NGO/Non-Profit-Desk Research",
"Guidebook", "NGO/Non-Profit-Guidebook",
"Training", "NGO/Non-Profit-Training",
"CUMULUS", "NGO/Non-Profit-CUMULUS",
"Other", "NGO/Non-Profit-Other"))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
RebeccaGarcia-P
3 years agoQrew Member
Now the error is:
Formula Error -- Type Mismatch
The expression [Customer Type] on the left hand side of the operator "=" is of type textlist while the expression "Corporate Coalition" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions.
You may need to do one of the following to fix the problem:
------------------------------
Rebecca Garcia-Pons
------------------------------
Formula Error -- Type Mismatch
The expression [Customer Type] on the left hand side of the operator "=" is of type textlist while the expression "Corporate Coalition" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions.
You may need to do one of the following to fix the problem:
- Add a type conversion function.
- Choose a different operator.
------------------------------
Rebecca Garcia-Pons
------------------------------
- MichaelTamoush3 years agoQrew CaptainWhat type of formula field is [Customer Type]? Is it a combined text field?
Try If(totext([Customer Type) = "Corporate Coalition",
If the error solves it self in the first instance, do that to all instances.
------------------------------
Michael Tamoush
------------------------------ - MarkShnier__You3 years agoQrew Champion... further to Mike's post above, what if the record has more than one Customer Type selected. What do you want the formula to do.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - RebeccaGarcia-P3 years agoQrew MemberThat worked! Thank you both so much!
------------------------------
Rebecca Garcia-Pons
------------------------------