We have a task type values (Sales Visit, Meeting, Email, Phonecall, Other). I need help on what formula to use that if the task values are Sales Visit or Meeting it should count as "1". And if the values are Email, Phonecall, Other it should be "O". Anyone who could help me will be much appreciated.
This will be used in my Market analysis Report.
3 个回答
You can create a number formula field like below and can use that field to identify task type count.
CASE(Task_type__c,
"Sales Visit", 1,
"Meeting", 1,
0
)