I am Trying to create a report on Object__c. So I am trying to use user custom field(projectName__c) value in custom object field(projectName__c) in filter in Reports.
For that, I got a suggestion to do like below, and filter with Boolean.
Create a formula field in the custom object which is checkbox type and formula will be
IF(projectName__c=user.projectName__c,true,false)
And create a report where apply filter forumulaField__c = true
.
So, This is working fine. But When I change projectName__c, The all same projectName__c record's will be updated. If I change it to another project again records will be updated. I will have 1 Million records in my application, Presently I am using developer account.
Does This updating on 1 Million records meets any governor limits?