+ Start a Discussion
The new LearnerThe new Learner 

Image population using formula field

I have to populate the image based on the below conditions.

1. when the record type is "sales" or "service" and Date__c is greater than (Today() -160) then it should be green.
2. when the record type is "sales" or "service" and Date__c is less than (Today() -160) then it should be red.
3. when the record type is "sales" or "service" or "marketing" and status is not equal "renewed" and date__c <today then it should be red.
4. when image__c field is is not blank then it should it should be grey.

can anyone help me please.
Best Answer chosen by The new Learner
The new LearnerThe new Learner
no abhishek,

Still i am facing issues with that formula. its not turning to red 

All Answers

AbhishekAbhishek (Salesforce Developers) 
Hi,

Your query is already answered here.

https://trailblazers.salesforce.com/answers?id=9064S000000D75hQAC

You can close this thread.

Thanks.
The new LearnerThe new Learner
no abhishek,

Still i am facing issues with that formula. its not turning to red 
This was selected as the best answer