• syed Imran
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies

Hi all, 

Looks like we cannot add formual fields in Edit Multi line layout on Opportunity product.

Is there any solution of it.

 

  • September 06, 2022
  • Like
  • 0
Hi Team,

I've two Objects Object1 & Object2

Each Object have one Picklist:
Object1>Picklist1
Object2>Picklist2

I want to display value selected in Picklist1 should automatically display in Picklist2.

Ofcourse we can try Flow, But

I want to achieve it by writing Formula under 
Setup>Object manager>Object2>Fields & Relationships> Picklist2> Gebneral Options> Default Value > Formula Editor.

any one have any idea on how to write formula for it?
I am trying to check our state and country fields to make sure they are being entered correctly from an integration and get a notification if a state or country is incorrect. However, the Contains function does not seem to want to work with the : to separate multiples. I am getting strange results. For example with the following short version if I put anything, including the specified names, into the field I get a result of "unknown".
IF(CONTAINS(UPPER(MailingCountry), "AUSTRALIA:BRITAIN:CANADA"), "Known", "Unknown")

but if I switch the MailingCountry to the end of the formula then it kinda works except even partial pieces of the names get set as "known" such as US and AIN. And that's not helpful.
IF(CONTAINS( "AUSTRALIA:BRITAIN:CANADA", UPPER(MailingCountry)), "Known","Unknown")

I've tried moving things around and just can't figure out why it doesn't work at all one way and then is too lenient the other way and matching things that aren't supposed to be matched. I don't want to use nested if then statements for each state/country because not only would that be tedious it would also go over the allowed formula length. Any insight would be greatly appreciated.