+ Start a Discussion
abi060988abi060988 

count the no.of assignments done to another user

How to get the count of records which are assigned to another user.

 

I created a lookup called assign to in the leads and assigned a lead to another user. How to get the count of no.of records assigned to another user.

Josephadm401Josephadm401

I believe this is what you are looking for. Create a report on Leads and add the created lookup field to the report. Then use filter criteria to state:

 

 "assign to" Not Equal To "Leave this blank"

 

If you are trying to count the number of time a record has been assignedm then your will have to create a number field and use a field update with the following formula:

 

IF(ISNULL( number1__c ),1, number1__c + 1)

 

The workflow rule would then state that it would need to fire every time the record is edited and the formula would evaluate to true as following:

 

ISCHANGED(Assign_To__c)

goabhigogoabhigo

I think reports will solve this. Run a report and just summarize with Assign To field for today or this week or this month (in time frame, according to your need).

goabhigogoabhigo

Is it solved or not yet?