Hi,
I have custom lookup field in a account object 
lookup to the user

My question is i have to prepopulate the field with the user name that means owner of the account

please help me to sort out this

Thanks & Regards
Pratyusha.K

Hi,
this is my formula field ( CASE(CASE(BillingState ,
                    'BC', 1,
                    'CA', 1,
                    'NV', 1,
                    'OR', 1,
                    'WA', 1,
                    'YT', 1,
                    'AB', 2,
                    'AZ', 2,
                    'CO', 2,
                    'ID', 2,
                    'MT', 2,
                    'NM', 2,
                    'UT', 2,
                    'WY', 2,
                    'AL', 3,
                    'AR', 3,
                    'IL', 3,
                    'IA', 3,
                    'KS', 3,
                    'LA', 3,
                    'MB', 3,
                    'MN', 3,
                    'MS', 3,
                    'MO', 3,
                    'NE', 3,
                    'ND', 3,
                    'OK', 3,
                    'SD', 3,
                    'SK', 3,
                    'WI', 3,
                    'CT', 4,
                    'DE', 4,
                    'GA', 4,
                    'ME', 4,
                    'MD', 4,
                    'MA', 4,
                    'MI', 4,
                    'NH', 4,
                    'NJ', 4,
                    'NY', 4,
                    'NC', 4,
                    'OH', 4,
                    'ON', 4,
                    'PA', 4,
                    'QC', 4,
                    'RI', 4,
                    'SC', 4,
                    'VT', 4,
                    'VA', 4,
                    'WV', 4,
                    'AK', 5,
                    'HI', 6,
                    'FL', IF(MID(Phone,2,3) = "850",3,4),
                    'IN', IF(MID(Phone,2,3) = "219",3,4),
                    'KY', IF(MID(Phone,2,3) = "270",3,4),
                    'TX', IF(MID(Phone,2,3) = "915",2,3),
                    'TN', CASE(MID(Phone,2,3),"865",4,"423",3,0),
                    0),
     1,-8,
     2,-7,
     3,-6,
     4,-5,
     5,-9,
     6,-10,
     0))
the result  it was displaying was 8,7 for example

but i want the output as GMT-8

Please suggest me the modifications

Thanks & Regards
Pratyusha.K

Hi,
i want local time field for my account object based on billing state the time should be generated should be generated

pplease help me to sort out this

thanks

I Have BDR role which contains 4 team leaders Suppose W, X,Y,Z and SDR which contains 5 juniors 

i want to assign 5 junoirs to X 

how to do it 
please help me to sort out this 

TH
thanks&regards
Pratyusha.k




 

Hi,
Iam new to the sandbox please help to move changes or code i have made in sandbox to production

Thanks & Regards
Pratyusha K

Hi
anyone can provide me backend support to me for my current small sales project
if interested please contact me on pratyusha.salesforce@gmail.com 
please help me

Thanks & Regards
Pratyusha K

Hi
i have used a text formula field but it has some error in the formula
IF(ispickval(Sub_type__c, "Saas"), "6",
   if(ispickval(Sub_type__c, "On-Prem"), "12","None"
   )
)

Error: Field Sub_type__c may not be used in this type of formula

i have used case also it is also displaying same error

plz help to sort out this plz

Thanks & Regards
Pratyusha k
 

Hi,
I have custom lookup field in a account object 
lookup to the user

My question is i have to prepopulate the field with the user name that means owner of the account

please help me to sort out this

Thanks & Regards
Pratyusha.K

Hi,
I have custom lookup field in a account object 
lookup to the user

My question is i have to prepopulate the field with the user name that means owner of the account

please help me to sort out this

Thanks & Regards
Pratyusha.K

Hi
i have used a text formula field but it has some error in the formula
IF(ispickval(Sub_type__c, "Saas"), "6",
   if(ispickval(Sub_type__c, "On-Prem"), "12","None"
   )
)

Error: Field Sub_type__c may not be used in this type of formula

i have used case also it is also displaying same error

plz help to sort out this plz

Thanks & Regards
Pratyusha k