Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Creating a custom column to tag items from two separate tables

 Hi,   I am trying to create a column where I want to create a tag coming from two separate columns. I'm not really sure if the SWITCH function would fit my need. Hoping you could help me on this o...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous! What about if Mobile and Email column contains "NULL" where the tag should be No SMS and EMAIL whereas the Mobile and Email column both contains an item and the tag should be With SMS and EMAIL?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

 

in that case this should work :

Contactability = if(AND(SampleData[Mobile] = "NULL",SampleData[Email] = "NULL"),"NO EMAIL AND SMS",
				if(AND(SampleData[Email] = "NULL",SampleData[Mobile] <> "NULL"),"SMS Only",if(AND(SampleData[Email] <> "NULL",SampleData[Mobile] = "NULL"),"EMAIL Only","With SMS and EMAIL")))

 

If I answer your question! Mark my post as a solution! 

 

Thanks,

Jayant

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous! it does work but it does not work correctly on all items. Would you know why? I have already treated the data by replacing all the blanks into "NULL" but I still get this. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Can you paste your Data here. So that I can use the same and try code again.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous apologies for the late response. 

         

        Here you go.

         

         

        From the table above, I want to tag those that have an email only, sms only, with email and sms and no sms and email.