You need to sign in to do that
Don't have an account?
Jared Kane
Help With an IF(ISPICKVAL formula
I am trying to have a dollar sign image show up on another field called stage_indicator__c whenever "delivered" from the stage picklist is chosen.Whenever other value is chosen from the picklist, I want it to be blank. My current formula isnt working. Any thoughts on where i'm going wrong? Im pretty new to this.
IF(ISPICKVAL(Stage_Name__c, "Delivered"),"IMAGE("/servlet/servlet.FileDownload?file=015A0000003mNPL","")
IF(ISPICKVAL(Stage_Name__c, "Delivered"),"IMAGE("/servlet/servlet.FileDownload?file=015A0000003mNPL","")
Basically your IF function is testing the first condition, if that is TRUE (in this case StageName = Delivered), then it is displaying your image. If it isn't true then you are displaying nothing ("").
What you want to do is the first IF isn't true is do another IF statement inside your first one, so if the first one doesn't evaluate as true the formulat will test the second one, you can continue to nest IF statements like this. Here is an exmaple, I didn't give it a new image ID for the second image function so you will need to update, and be careful tha tyou have the right number of closing paretheses.
All Answers
Use below formula: Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.
Basically your IF function is testing the first condition, if that is TRUE (in this case StageName = Delivered), then it is displaying your image. If it isn't true then you are displaying nothing ("").
What you want to do is the first IF isn't true is do another IF statement inside your first one, so if the first one doesn't evaluate as true the formulat will test the second one, you can continue to nest IF statements like this. Here is an exmaple, I didn't give it a new image ID for the second image function so you will need to update, and be careful tha tyou have the right number of closing paretheses.