3 Replies Latest reply on May 23, 2018 6:49 AM by Philippe Mudra

    Filter condition as formula for if Null or of more then 3 letters

    Philippe Mudra

      Hi Community,

       

      I am working on a filter condition by a formula to show up all Opportunities with the following filter on country.

      All Countries are saved as ISO 2 code. So max letters are 2.

      Example:

      US = USA

      DE = Germany

      FR = France

       

      But we all know sometimes a country will no be delivered or correctly saved.

      Filter formular:

      IF Country is NULL or if Country (Letters > 2) then show up.

      SOmething like that but in a correct way.

       

      I hope someone understand my problem and give me a hint.

      Many thanks,

      Phil