Collect cell value based on two check boxes in another sheet

Options

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

Best Answer

  • Victoria_Indimar
    Victoria_Indimar ✭✭✭✭✭
    Answer ✓
    Options

    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.

Answers

  • Victoria_Indimar
    Victoria_Indimar ✭✭✭✭✭
    Answer ✓
    Options

    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
    Ronald Anderson ✭✭✭✭
    Options

    ;Thank you Victoria!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!