+ Start a Discussion
jgreene.ax1178jgreene.ax1178 

Image Formula On Top Of Old Formula!

Hey all!

Would love to make this formula work, but I am not quite sure howo do so yet.

TODAY() - LastActivityDate

IF
( pi__score__c >=100, IMAGE("/img/samples/flag_green.gif","Greater Than 100 "),
IF
( pi__score__c <=49,IMAGE("/img/samples/flag_red.gif","Less than 49 "),

IMAGE("/img/samples/flag_yellow.gif","null")
)
)

The first part of this whole mess has been around for about 3 years, and the IF formula is the new addition I would like to make work.

Thoughts?

Thanks!
ShashForceShashForce
Is there an error you are seeing when trying this formula?
Andy BoettcherAndy Boettcher
At first blush - you should take the "TODAY() - LastActivityDate" part and put it in place of your "pi__score__c" text in the formula.
jgreene.ax1178jgreene.ax1178
@Shashank_SFDC - yup, it's just a syntax that really doesn't point to anything impaticular.  I need that first formula to work seperate from the 'IF' statement.

Make sense?

And thanks!!