Nested Case formula issue / snapshot field
I'm relatively new to formulas and having an issue with a nested case statement. The main thing I'm trying to accomplish is setting up a snapshot field for target profit margin. I created a new table,...
Forum Discussion
Only have a second to look now, but on firs glance try this, i only copy/paste the first 3 but you will get the idea
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"))
------------------------------
Michael Tamoush
------------------------------
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"))
------------------------------
Michael Tamoush
------------------------------
- Thanks for the quick reply! I tried it, but now the error says 'expecting bool but found textlist'
------------------------------
Rebecca Garcia-Pons
------------------------------- MarkShnier__You
Qrew Legend
What is the field type of your formula field?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- It's text. Should it be something else?
------------------------------
Rebecca Garcia-Pons
------------------------------
