Hello all,
I've created a custom field called "Case_Queue__c" on the Case object. I want the field to display the name of the Queue the case is currently assigned to.
I thought I could use a formula on text field but it's not working:
IF( Owner:Queue.Id <> null, Owner:Queue.QueueName, "No Value" )
What am I missing, please?
Thank you,B3 réponses
IF( LEFT( OwnerId ,3) = "00G", Owner:Queue.Name, "Not Queue")Remember the OwnerId field can contain either a User or a Queue. So we test for the prefix for Queues (00G), and if it is a Queue, drive to the Queue name via the lookup field.RegardsAndrew
