Jimrny✭✭

Got it. Didn't think it would count more than the rows that are actually filled. Was able to get my results by filtering per year.

@Paul Newcome That makes sense to count the range with true values being greater than 0. Thank you so much!!

This seems to be the formula! =INDEX(COLLECT({NotesRef}, {OperatorRef}, [Operator Name]@row, {MonthRef}, Month@row), 1)

@Paul Newcome Sorry I mean, I was trying to display the text "MECHANICAL" in front of the joined values. MECHANICAL - Response, Reoccurring, Equipment I tried adding ="Mechanical" + String, but it leaves the value there if there are no check boxes selected.

@Paul Newcome This worked out perfectly! Any chance you could answer this question about adding a pre-fix if the check boxes are true or not? =IF(ISBLANK(Response@row:Equipment@row), "", "Mechanical - " + IF(COUNTIFS(Response@row:Equipment@row, @cell = 1) = 1, SUBSTITUTE(IF(Response@row = 1, "Response, ", "") +…

=IF(Response@row = 1, "Response, ", "") + IF(Reoccurring@row = 1, "Reoccurring, ", "") + IF(Technician@row = 1, "Technician, ", "") + IF([Set-Up]@row = 1, "Set-Up, ", "") + IF(Equipment@row = 1, "Equipment", "") Fixed my "0" issue, just trying to figure out the best way to have the delimiter drop if there's only one box…

@Paul Newcome , thank you! Another question I have is, if only 1 box is checked, is it possible to drop the delimiter? It also shows a 0 when no boxes are checked, or when technician/set-up/equipment is selected alone. But seems to be fine when all are selected I'm using: =IF(Response@row = 1, "Response, ") +…

@Paul Newcome is amazing! Always helpful!

Eureka! Didn't even think about that! Thank you

它仍然给了我只有7个字符,一旦时间end time is XX:XX PM versus X:XX PM, it will only give me the 7 characters.