-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
4Questions
-
0Replies
Need Help With An Advanced Region Formula
I need a region formula based off states and countries, but for New York and New Jersey it is also based of the account name that starts with #-J and K-Z? Here is what im working with, but i know its not right.The bold area is what needs to be fixed. Any help would be amazing.
IF(LEN(BillingState)=0, "None",
IF(CONTAINS("WA:OR:CA:AZ:NM:TX:HI:AK", BillingState), "West",
IF(CONTAINS("ID:NV:UT:MT:WY:CO:ND:SD:NE:KS:OK:MN:IA:MO:AR", BillingState), "Central",
IF(CONTAINS("LA:TN:MS:AL:FL:GA:SC:NC:VA:WV:DC:MD:DE:PA", BillingState), "Southeast",
IF(CONTAINS("PR", BillingCountry), "Great Lakes",
IF(CONTAINS("WI:IL:MI:IN:KY:OH", BillingState), "Great Lakes",
IF(CONTAINS("NY:NJ", BillingState), "East",
IF( BEGINS(Name, "A, B, C, D, E, F, G, H, I, J"), "East 1",
IF( BEGINS(Name, "K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z"), "East 2",
IF(CONTAINS("AD:AL:AT:BA:BE:BG:BY:CH:CZ:DE:DK:EE:ES:FI:FO:FR:FX:GB:GI:GR:HR:HU:IE:IS:IT:LI:LT:LU:LV:MC:MD:MK:MT:NL:NO:PL:PT:RO:SE:SI:SJ:SK:SM:UA:VA:CS:UK", BillingCountry), "East",
IF(CONTAINS("CA:JM", BillingCountry), "Central",
IF(CONTAINS("CT:RI:MA:NH:VT:ME", BillingState), "New England", "Other"))))))))))))
-
- moringd
- June 20, 2011
- Like
- 0
- Continue reading or reply
Select multiple to campaigns in Web-to-Lead
is it possible to select multiple campaigns within a web-to-lead form?
For example, i would i like to use so that if a prospect want to request multiple webinar replays, they can do it from one form and not have to fill out a form everytime.
-
- moringd
- February 10, 2011
- Like
- 0
- Continue reading or reply
Web-to-Lead Notification
Does anyone know if there is a way to have the notification email sent to multiple recipients? Or can it onle sent to one.
-
- moringd
- February 10, 2011
- Like
- 0
- Continue reading or reply
Web-to-Lead and Campaign Member Custom Fields
Does anyone know the code or if it is possible to populate a Campaign Member Custom Fields via the web-to-lead form?
If so, can someone share some sample code? I have been tryiing all day and cannot make it work.
-
- moringd
- February 04, 2011
- Like
- 0
- Continue reading or reply