Salesforce Formula Text Value Based on Custom Field Picklist Value

0 votes

on Cases, I have:

Department(picklist values=Ecom, B2B, etc.) Manager(text field) Employee 1(text field) Employee 2(text field) Employee 3(text field) Employee 4(text field)

This is what I am trying to do in real time, not on save (workflow rule won't work because it only does field updates after creating the ticket, not during the creation of it): IF(ISPICKVAL(Department__c, "Ecom"),Employee_1__c="John Smith", Employee_2__c="Jane Doe", etc.)

It keeps telling me I can't use a formula on the picklist field so then I tried to do it on each of the employee fields but they are not formula and only text fields.

I created another field that is Formula(text) and put in a formula:

IF(ISPICKVAL(Department__c,"Ecom"),"test",null)

This works but only for the formula(text) field, if I try to have it update the other text fields, it also does not allow me to do this and gives a boolean error, tried replacing null with "false" "true" with no difference.

Apr 8 in SalesForce by surbhi
• 3,810 points
13 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In SalesForce

0 votes
1 answer

Salesforce Formula Text Value Based on Custom Field Picklist Value

You should update the fields using the ...READ MORE

answered Mar 2 in SalesForce by surbhi
• 3,810 points
137 views
0 votes
0 answers

translation based on quote language in conga templates salesforce

I have a requirement to translate quote ...READ MORE

Apr 11 in SalesForce by surbhi
• 3,810 points
50 views
0 votes
1 answer

Salesforce Apex/JSON serialization with change on variable name

Apex does not support annotation for serialization. But, ...READ MORE

answered Mar 2 in SalesForce by surbhi
• 3,810 points
132 views
+2 votes
2 answers

Salesforce Interview questions

Here are some questions very important for ...READ MORE

answered Jan 11, 2019 in Career Counselling by Suresh
• 720 points
1,832 views
0 votes
1 answer

How to connect to salesforce from tableau?

Hi, follow these steps to connect to Salesforce: 1. ...READ MORE

answered Mar 25, 2019 in Tableau by Cherukuri
• 33,010 points
287 views
0 votes
1 answer

Power BI - Salesforce

Hi, Follow below steps: 1. Go to Data source. 2. ...READ MORE

answered Mar 25, 2019 in Power BI by Cherukuri
• 33,010 points
173 views
0 votes
1 answer

What is the best training for Salesforce ADM-201 Exam?

Hi @Vardhan, I took Edureka's Salesforce Training that covers all ...READ MORE

answered Jun 3, 2021 in Others by Jaya
• 140 points

edited Dec 22, 2021 by Soumya 202 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP