Forum Discussion

Kelly-AnnTainto's avatar
Kelly-AnnTainto
Qrew Cadet
2 months ago
Solved

If Then Else formula with a multi select field.

Help Please.   I have a multi-select field that has the options of Mail, Email and Dept to Initiate.  Mail and Email can both be options.  In that case, I want it to display "Mail and Email".  But if...
formulas
  • Kelly-AnnTainto's avatar
    Kelly-AnnTainto
    2 months ago

    After I wrote my last response and re-read yours, I realized I made this way overcomplicated.  There is a VERY simple way to do what I'm trying to do.   

    If(ToText([License Master - Renewals Received via:])="",ToText([Renewals Received via:]),ToText([License Master - Renewals Received via:]));

    Yikes.  Thanks for your help. 

     

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

I went a bit crosses eyed trying to look at your formula, but it seems to me that you simply want to list whatever options the user selected separated by " and ", is that right?

 

If that is the case, try this

var text Receipt =

 SearchAndReplace(ToText([License Master - Renewals Received via:]), " ; ", " and ");

"<span style='font-size:18px;color:#1E90FF;white-space:nowrap'><b>"&$Receipt&"</b></span><br>";

 

note that its possible that the confusiton that to were having is that the phrase email contains the word mail 

so both email and mail contain mail.

 

 

 

Kelly-AnnTainto's avatar
Kelly-AnnTainto
Qrew Cadet
2 months ago

After I wrote my last response and re-read yours, I realized I made this way overcomplicated.  There is a VERY simple way to do what I'm trying to do.   

If(ToText([License Master - Renewals Received via:])="",ToText([Renewals Received via:]),ToText([License Master - Renewals Received via:]));

Yikes.  Thanks for your help.