Collect cell value based on two check boxes in another sheet

Ronald Anderson

I am needing help to collect a value from a cell in a different sheet based on two boxes checked on that sheet.

I want to collect the value in [Event Level] based on the following criteria:

[Operational Area] = "Airside" / [Max Date] is checked and [Area] is checked

Regards,

Ron

Victoria_Indimar

Hello! Hopefully I followed you scenario correctly...

You could do a Helper field that combines the two checkbox fields. Then you can JOIN-COLLECT any values that have Helper = truetrue.

Helper Column with Column Formula: =JOIN([Max Date]@row:Area@row, "")

Your Collection field: =JOIN(COLLECT([Operational Area]:[Operational Area], Helper:Helper, ="truetrue"), ", ")

Hope this helps! Please let us know if that works for you.

Victoria_Indimar

Hello! Hopefully I followed you scenario correctly...

You could do a Helper field that combines the two checkbox fields. Then you can JOIN-COLLECT any values that have Helper = truetrue.

Helper Column with Column Formula: =JOIN([Max Date]@row:Area@row, "")

Your Collection field: =JOIN(COLLECT([Operational Area]:[Operational Area], Helper:Helper, ="truetrue"), ", ")

Hope this helps! Please let us know if that works for you.

Ronald Anderson

;Thank you Victoria!