function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jenny jadejenny jade 

Copy picklist value in a formula field for dynamic reports

I am trying to capture picklist field value in a formula of return type checkbox for reports
if the picklist value = the user then it should give true otherwise false

for ex:if the field was a lookup then I would write my formula as IF(lookup field name = $User.Id , True , False)

How should I implement the same for picklist ?
John Pipkin 14John Pipkin 14
Jenny, 

Try using 
TEXT(Picklist_Field__c) = $User.Id

The IF statement is not necessary since the condition of the IF statement already returns true or false. 

Hope that helps