You need to sign in to do that
Don't have an account?
jgreene.ax1178
Making an Image Formula!
Hey all!
Trying to make a formula that will show as a 'green flag' if this field is having a value of 100 or greater.
IF (pi__score__c > "100",IMAGE("/img/samples/flag-green.gif","green"),IMAGE("/img/samples/flag_red.gif","red"))
However I'm getting an error - any thoughts as to why? I'm wondering if it's because of the custom field?
Thanks!
Trying to make a formula that will show as a 'green flag' if this field is having a value of 100 or greater.
IF (pi__score__c > "100",IMAGE("/img/samples/flag-green.gif","green"),IMAGE("/img/samples/flag_red.gif","red"))
However I'm getting an error - any thoughts as to why? I'm wondering if it's because of the custom field?
Thanks!
is ur "pi__score__c " field a number data type.Then try this code :
IF
(pi_score__c >=100, IMAGE("/img/samples/flag_green.gif","Greater Than 100 "),
IF
( pi_score__c<=99,IMAGE("/img/samples/flag_red.gif","Less than 99 "),
IMAGE("/img/samples/flag_yellow.gif","null")
)
)
or
Refer to this link
http://www.shellblack.com/administration/using-image-formula-fields/
-Jake