Formula Help

Question

Hello!I'm struggling with writing a formula. Would love some assistance.Here is the situation....I have 150 product options for users to select from. They can select multiple products, but as we know, the multi-select text limits us to 100 options.So I created two fields: Field A and Field B (both multi-select text fields)I need a field that combines the two.I'd like the formula to work like this:If [Field A] and [Field B] are not blank, combine those two fields and separate the data with a semi-colon.If [Field A] is blank and [Field B] is blank, return a blank field.If [Field A] is blank and [Field B] is not blank, return the value in [Field B]If [Field B] is blank and [Field A] is not blank, return the value in [Field A]Can someone help me write that formula please? 
Thank you!!!------------------------------Karen Henke------------------------------

MarkShnierYou · Answer

npList(" ; ", ToText([field a]), ToText(field b]))If you would prefer to not have the separate as space semi space, but want the sepration to be something else like just a tight semi between, then you could do this var text LooseSemi = List(" ; ", ToText([field a]), ToText(field b]));SerachAndReplace($LooseSemi, " ; ", ";")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community