+ Start a Discussion
RaavipatiRaavipati 

for opportunbity tab i have a picklist field subtype according to the picklist field a field named type should be automatically updated

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
 
Best Answer chosen by Raavipati
Nishad KNishad K
Hi Pratyusha,
Try this formula,
IF(TEXT(Sub_type__c) = "Saas","6",
   IF(Text(Sub_type__c) = "On-Prem","12","None"
   )
)
Regards,
 

All Answers

Nishad KNishad K
Hi Pratyusha,
Try this formula,
IF(TEXT(Sub_type__c) = "Saas","6",
   IF(Text(Sub_type__c) = "On-Prem","12","None"
   )
)
Regards,
 
This was selected as the best answer
RaavipatiRaavipati
Hi Nishad,
thanks for your immediate rply
it was showing me the same error
can u suggest me anything else

Thanks & Regards
Pratyusha.k
RaavipatiRaavipati
Error: Field Sub_type__c may not be used in this type of formula
this was the error
Nishad KNishad K
Hi Pratyusha,
Use the "Advanced Formula" tab, then use the "Insert Field" button to include other fields - this way you never have to worry about types!!
RaavipatiRaavipati
Thank you very much
i dont know how to thank you it was working
Nishad KNishad K
If it's resolved please mark the answer !! and keep the community clean !!
RaavipatiRaavipati
one more question please help me
in opportunity tab i have three fields opportunity name,account name ,type .
type is a picklist field in that picklist if i selected additional account name automated by taking opportunity name as account name but oppornity name was the combination account name and vesion

as well as account name was standard look up field