Ask Search:
Denise HughesDenise Hughes 

How to show selected picklist value in email template?

I'm new to formulas, so any help is appreciated.  I want to send out email notifications when a case is created.  I need to display the picklist value the user selected on the case for the Priority field in the email.  I tried this and it did not work.  The Priority field in the email is blank.

Priority: {!IF(ISPICKVAL(Case.Priority,"Medium"),"Medium","Medium"),
IF(ISPICKVAL(Case.Priority,"Low"),"Low","Low"), 
IF(ISPICKVAL(Case.Priority,"High"),"High","High"),
IF(ISPICKVAL(Case.Priority,"Urgent"),"Urgent","Urgent"))))} 

When I only use this, it works fine.  The Priority field in the email is Medium.
Priority: {!IF(ISPICKVAL(Case.Priority,"Medium"),"Medium","Medium")}

Any suggestions?

Thanks!
Denise Hughes
 
Best Answer chosen by Denise Hughes
Amit SinghAmit Singh
Like this
{!IF(ISPICKVAL(Case.Priority,"Medium"),"Medium",
	IF(ISPICKVAL(Case.Priority,"Low"),"Low",
		IF(ISPICKVAL(Case.Priority,"High"),"High",
			IF(ISPICKVAL(Case.Priority,"Urgent"),"Urgent", ""))))}

 

All Answers

Deepak AnandDeepak Anand
What if you just wrote this =
{!TEXT(Case.Priority)}
Amit SinghAmit Singh
Like this
{!IF(ISPICKVAL(Case.Priority,"Medium"),"Medium",
	IF(ISPICKVAL(Case.Priority,"Low"),"Low",
		IF(ISPICKVAL(Case.Priority,"High"),"High",
			IF(ISPICKVAL(Case.Priority,"Urgent"),"Urgent", ""))))}

 
This was selected as the best answer
Denise HughesDenise Hughes
Hi Deepak,

I tried that and it didn't work.  I get a blank result.

Thanks!
Denise
Denise HughesDenise Hughes
Hi Amit,

That worked!  Thanks a lot!!
Amit SinghAmit Singh
Cheers :)