Re: If/Then statements in Exact Form - Need Help

I am almost there.   I got those field to work and show up on a list.   However, I also have a multi-select box that I got on the list by using  ToText but if numerous items are checked they show up on one line.    Anyway to get these to show on multiple lines?

Here is my formula.   Its itemfive that I am having the problem with.

var text itemone = If([Opportunity - Resident notification required]="YES","•" &  [Resident Notifications for Proposal],"");

var text itemtwo = If([Opportunity - NO Parking signs required]="YES","•" & [No Parking for Proposal], "");

var text itemthree =If([Opportunity - Sweeping Responsibility]="POST", "•" & [Sweeping Responsibility for Proposal],If([Opportunity - Sweeping Responsibility]="PRE/POST","•" & [Sweeping Responsibility for Proposal],""));

var text itemfour ="•" & "Furnish and Apply" & If([Opportunity - Product]="REC"," Reclamite",If([Opportunity - Product]="CRF"," CRF",""));

var text itemfive = "&#8226;" &If(ToText([CAM to])<>"",ToText([CAM to]));

List("<br>", $itemone, $itemtwo, $itemthree, $itemfour, $itemfive)

Tina Revermann

Operations Manager

Corrective Asphalt Materials, LLC

300 Daniel Boone Trail

South Roxana, IL 62087

618-254-3855 – office phone

618-484-7650 – Direct line/cell

618-254-2200 – fax