You need to sign in to do that
Don't have an account?
Etaussig
Help with ISPICKVAL IF AND FORMULA
I am trying to write a formula which compares 2 criteria, for quarterly reporting purposes. One is a picklist value and one is a text formula field. The scenario is this:
If ISPICKVAL = "MGM" and EXHIBITION MONTH = "JAN" THEN "MAR", EXHIBITION MONTH
OR
If ISPICKVAL = "MGM" and EXHIBITION MONTH = "FEB" THEN "MAR", EXHIBITION MONTH
OR
If ISPICKVAL = "MGM" and EXHIBITION MONTH = "APR" THEN "JUN", EXHIBITION MONTH...etc
Please help if you can. Thanks!
How about now?
IF(AND(ISPICKVAL( Picklist , "A"), FormulaField = "A"), "Result A",
IF(AND(ISPICKVAL( Picklist , "B"), FormulaField = "B"), "Result B",
IF(AND(ISPICKVAL( Picklist , "C"), FormulaField = "C"), "Result C",
FormulaField )))
All Answers
Sounds like you want a formula something like this:
IF(AND(ISPICKVAL( Picklist , "A"), FormulaField = "A"), "Result A",
IF(AND(ISPICKVAL( Picklist , "B"), FormulaField = "B"), "Result B",
IF(AND(ISPICKVAL( Picklist , "C"), FormulaField = "C"), "Result C",
FormulaField )))
How about now?
IF(AND(ISPICKVAL( Picklist , "A"), FormulaField = "A"), "Result A",
IF(AND(ISPICKVAL( Picklist , "B"), FormulaField = "B"), "Result B",
IF(AND(ISPICKVAL( Picklist , "C"), FormulaField = "C"), "Result C",
FormulaField )))
Ok. SO now I have a new problem. Stevemo's solution worked great, here is what I have:
But now I need to do this for 5 different studios, and when I add the second studio, I get the error message:
Error: Compiled formula is too big to execute (6,554 characters). Maximum size is 5,000 characters
Does anyone have any thoughts as to how I can make this formula smaller? Maybe using Contains?
Thanks in advance for any help.
IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "JAN"), "MAR",IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "FEB"), "MAR",IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "APR"), "JUN", IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "MAY"), "JUN", IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "JUL"), "SEP", IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "AUG"), "SEP", IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "OCT"), "DEC", IF(AND(ISPICKVAL( Studio__c , "MGM"), EXHIBITION_MONTH__c = "NOV"), "DEC",
IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "JAN"), "MAR",IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "FEB"), "MAR",IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "APR"), "JUN", IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "MAY"), "JUN", IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "JUL"), "SEP", IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "AUG"), "SEP", IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "OCT"), "DEC", IF(AND(ISPICKVAL( Studio__c , "ICON"), EXHIBITION_MONTH__c = "NOV"), "DEC",
EXHIBITION_MONTH__c ))))))))))))))))
Error: Field State_and_Provision__c is a picklist field. Picklist fields are only supported in certain functions.
pls help
@steve Can you help me?
I want to create a formula which is a combination of IF statement and maybe Ispickval!
The logic should be:
If owner Id = "112121212!2" than update a picklist value called "Apple" from the field Fruits
Thanks in advance!
I´m trying something similar but depending on my picklist value i wnat to show an image. Currently Saysing I'm missing ")" but I have counted and I can't find the error.
IF(
ISPICKVAL( Kundenloyalitaet__c , "sehr hoch") ,
IMAGE("https://LINK1", "golden-laurel" [, 929, 820]),
IF
(ISPICKVAL( Kundenloyalitaet__c , "hoch") ,
IMAGE("https://LINK2", "Gold_medal" [, 320, 233]),
IF
(ISPICKVAL( Kundenloyalitaet__c , "mittel") ,
IMAGE("https://LINK3", "Silver_medal" [, 322, 251]),
IF
(ISPICKVAL( Kundenloyalitaet__c , "gering") ,
IMAGE("https://LINK4", "Bronze_Medal" [, 332, 248]),
)
)
)
)
"hoch", IMAGE("https://LINK2", "Gold_medal" [, 320, 233]),
"mittel", IMAGE("https://LINK3", "Silver_medal" [, 322, 251]),
"gering", IMAGE("https://LINK4", "Bronze_Medal" [, 332, 248]),”unknow”)
try using "case" function insted of "if"