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! 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. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    I have used your data and applied the sample calculated column that I have applied earlier.

     

    Contactability = if(AND(SampleData[Mobile] = "NULL",SampleData[Email] = "NULL"),"NO EMAIL AND NO 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")))

     

    Thanks,

    Jayant