@Jason Semall , the pattern would be IF(CONTAINS('damx',test3),'damx','') So CONCAT(Pattern1,Pattern2,Pattern3,Pattern4,Pattern5) where pattern is IF(CONTAINS('checkbox option',checkboxfield),'checkbox option','') CONCAT( IF(CONTAINS('dam1',test3),'dam1','') , IF(CONTAINS('dam2',test3),'dam2','') , ...