FavoriteAMAN RANA (Always a Learner) asked in #Ask An ExpertApr 4, 2019, 10:56 AMI have(Account and opportunity)object there's picklist field in acc. object as rating (Hot,Warm,Cold) make a formula field in opp. name as rating when i choose in acc. rating Hot then it gonna show in opp.rating A.what will be the syntax?9 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Aladin Banwal (Tata Consultancy Services)Apr 4, 2019, 11:18 AMHello Aman, Try this:IF( ISPICKVAL(Account.Rating, "Hot"), "A", IF( ISPICKVAL(Account.Rating, "Warm"), "B", "C" )) Thanks! AladinShow MoreAdd a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Aladin Banwal (Tata Consultancy Services)Apr 4, 2019, 11:18 AMHello Aman, Try this:IF( ISPICKVAL(Account.Rating, "Hot"), "A", IF( ISPICKVAL(Account.Rating, "Warm"), "B", "C" )) Thanks! AladinShow More