I am trying to create a TEXT Formula where:
If Created By Profile is 1 of the 3 (EU User 1, EU User 2, EU User 3) / 'EU' if NOT Created by 1 of those Profile 'NA'
How would I do this?
8 个回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
You're missing some quotation marks afetr the 2nd and 3rd profile names. Also, as Skot wrote, you should use CreatedBy.Profile.Name:
CASE(
CreatedBy.Profile.Name,
"EU Sales User", "EU",
"EU Client Services", "EU",
"EU Sales Manager", "EU",
"NA"
)
