Forum Discussion

emma313823's avatar
emma313823
Icon for Helper V rankHelper V
5 years ago
Solved

How to do an if then

Hi All, I have a scenario I need help with. In my data I have a column called distributor. There can be many distributor names - like Arrow, Digi-Key, Master, etc. and there are blanks. The blanks m...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey emma313823 ,

     

    you can do that with a calculated column and the following code:

    OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey emma313823 ,

 

you can do that with a calculated column and the following code:

OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis