+ Start a Discussion
OssieOssie 

Simple Formula Field

Hi All,

 

I dont usually have any issues with formulas but for some reason i cant get this simple text formula below to work and so would appreciate any help please.

 

Upon the creation of a case i would like to populate let say field abc__c with the value of a team depending on the person which has created the record/case. 

 

I have tried all of the following, BUT none seem to work:

 

- IF(OwnerId = "005D0000001CFnlIAG", "Team A", Null)

- IF(CreatedBy.Alias = "JoeBloggs", "Team A", Null)

- IF( CreatedById = "005D0000001CFnl", "Team A", Null)

 

Thanks in Advance

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

I think I might have it formulas only use ID-15 nor ID-18

 

IF(OwnerId = "005D0000001CFnl", "Team A", 
IF(CreatedBy.Alias = "JoeBloggs", "TEST",
IF(CreatedById = "005D0000001CFnl", "TEST", NULL)))

 

All Answers

SteveMo__cSteveMo__c
IF(OwnerId = "005D0000001CFnlIAG", "Team A", 
IF(CreatedBy.Alias = "JoeBloggs", "TEST",
IF(CreatedById = "005D0000001CFnl", "TEST", NULL)))

 

OssieOssie

Thanka for the quick response, but it doesnt work. 

I have tried selecting just one of the If statments below, and still failed. 

SteveMo__cSteveMo__c

I think I might have it formulas only use ID-15 nor ID-18

 

IF(OwnerId = "005D0000001CFnl", "Team A", 
IF(CreatedBy.Alias = "JoeBloggs", "TEST",
IF(CreatedById = "005D0000001CFnl", "TEST", NULL)))

 

This was selected as the best answer
OssieOssie

Topman! Worked!