if Function for setting a Status with 1
Hello
I have in the ZOHO CRM a status with different names ( "A - Lead Nurturing" or "Lead Nurturing beendet").
Now I wanna make a dashboard to know, how many leads have the status "A - Lead Nurturing" or "Lead Nurturing beendet".
I need the formula in a pivot table, to write in the line, if the status is "A - Lead Nurturing" a number 1.
If in Column "Status" is "A - Lead Nurturing" write in new cell "1"
Thanks for help.