You need to sign in to do that
Don't have an account?
Peyman Heydari
case
Hi, I am getting this error when trying to save this formula. Any idea what I need to do to fix this? Thanks so much.
function readOnly(count){ }
You need to sign in to do that
Don't have an account?
Can you try the below logic, Case may not work in this scenerio
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
All Answers
Can you share the formula as comment as it is hard to understand from screenshot and also let us know what you are trying to achieve here.
Thanks,
CASE( Rating , Likely_Decision_Date__c > TODAY() + 31, "Warm", Likely_Decision_Date__c < TODAY() + 30, "Hot", "Cold")
The error is: Incorrect parameter type for function 'CASE()'. Expected , received Boolean
Can you try the below logic, Case may not work in this scenerio
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
I was able to save your formula with no errors, however it does not work on the Lead page. For example, I tried to create a new record with the "Likely Decision Date" of 10-28-22 which is less than 30 days, in this case the Rating is suppose to change to Hot, but Rating did not change at all.
In this scenerio you should not be using formula. When you use formule then the formula field itself will change not the other field. Which means the formula field which you created will change to Hot, cold or warm. If you want the above you may have to use flow .
Thanks,