You need to sign in to do that
Don't have an account?
Bryn Leahy 18
Pass through text formula if picklist criteria is met
I have a formula text field that looks up the Account_Owner_Role__c (text) from the Account record.
I now need the formula to populate only if a text field on the Account contains "Hunter"
This is what I've tried:
IF(
OR(
TEXT(Sales_Role__c)='Hunter - 1',
TEXT(Sales_Role__c)='Hunter - 2',
TEXT(Sales_Role__c)='Manager - Hunter 1')
),
Account_Owner_Role__c
))
Please try below
All Answers
Please try below
you need to try below rule.
IF( CONTAINS( Sales_Role__c, 'Hunter') , Account_Owner_Role__c, '')
don't forget to mark it as best answer.
Thank you
Was the solution helpful?