You need to sign in to do that
Don't have an account?
Rytec Administrator
Error: Syntax error. Missing ')' in formula
IF( ROI_No_of_Months__c < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30)
IF( ROI_No_of_Months__c > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30),
))
Any help would be appreciated. Thanks!
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30)
IF( ROI_No_of_Months__c > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30),
))
Any help would be appreciated. Thanks!
IF( ROI_No_of_Months__c < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30),
IF( ROI_No_of_Months__c > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30)
))
All Answers
IF( ROI_No_of_Months__c < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30),
IF( ROI_No_of_Months__c > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30)
))
Please copy this code and paste your side :-
If this solution is usefull for you, Please mark as a Best Answer to help others.
Regards
Mukesh
The requirement now is to add gray indicator if the ROI months are greater than 36.
Red for greater than 24 but less than or = 36 months.
Yellow for greater than or = to 13 but less than 24 and green for less than 13.
Gray >36
red 25-36 months
yellow 13-24 months
green 1-12 months
I really appreciate your help. The code above did work for every color but was missing yellow. Many thanks!!! Have a great day! :)
ROI_No_of_Months__c < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30),
IF(
AND(
ROI_No_of_Months__c >= 13,
ROI_No_of_Months__c <= 24
),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IF(
AND(
ROI_No_of_Months__c >= 25,
ROI_No_of_Months__c <= 36
),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30)
IF(
ROI_No_of_Months__c > 36,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFlp", "gray", 20, 20),
),
)
)
)
)
Hello wizards, what's wrong with this code? First it says it doesn't recognize >= and <= and when you add quotations, it starts with: syntax error missing ')'. Trying to do 12 months running sales. Please help.
IF(
AND(Opportunity.CloseDate:UNIQUE ">=" (TODAY() - 365),
Opportunity.CloseDate:UNIQUE "<=" TODAY()
),
Opportunity.ExpectedRevenue.CONVERT:UNIQUE,
0
)