KathyBenjamin
3 years agoQrew Trainee
Concatenate A field based on if a checkbox is checked
I'm trying to create a formula based on the following and having no luck.  If you have any suggestions they would be truly appreciated.
If [New Medical Plan] is not null OR [New Dental Plan] is not null OR [New Vision Plan] is not null Concatenate [Control],[Suffix],[State]
Thank you
------------------------------
Kathy Benjamin
------------------------------
If [New Medical Plan] is not null OR [New Dental Plan] is not null OR [New Vision Plan] is not null Concatenate [Control],[Suffix],[State]
Thank you
------------------------------
Kathy Benjamin
------------------------------
- Sure,
 Can you tell us the field type of these fields?
 [New Medical Plan]
 [New Dental Plan]
 [New Vision Plan]
 ------------------------------
 Mark Shnier (Your Quickbase Coach)
 mark.shnier@gmail.com
 ------------------------------