Need to amend a report from my predecessor that will show all the tasks which are created by a user but not assigned to them (and vice versa) e.g. Created by MR A and Assigned to MR B - NEVER Created by MR A and Assigned to MR A or Created by MR B and Assigned to MR B

Is there a simple way to do this without typing the user's names in the 'assigned to equals' and 'created by not equals to' filters on the report? (there are quite a few users and is also hard to manage if adding/ removing manually!)

N.B. All users do belong the same role for this report


This approach can work

  • Add a new checkbox formula field on Task, called Is_Assigned_to_Creator__c
  • Formula is CreatedById = OwnerId
  • Change the report filter to look for Is_Assigned_to_Creator__c = false to find all Tasks assigned to someone other than the creator. Use additional filters for specific usernames
  • Perfect! Works 100% – TheAdmin Jan 26 '17 at 16:06

I am afraid that it is not possible yet to compare a field to another field in Salesforce reports. But you can upvote the following idea of improvement:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.