Index / Match with Checkboxes

I am trying to pull into my Team sheet summary as the "Status Phase" the value of "Project Phase" from my Status sheet when the "Final Version" checkbox has been checked. I am using the following formula but it won't read the checkbox value, it doesn't matter if it's checked or unchecked. Can't figure out what I am doing wrong.

Formula in Team sheet: =IFERROR(INDEX({STATUS - Project Phase}, MATCH(1, {STATUS - Final Version}, 0)), "")

If I change the format of my "Final Version" column in my Status sheet to be text with the option of "Yes" or "No" instead of a check box and I update my MATCH criteria from 1 to "Yes" it works.

Is there an issue trying to use the checkbox in a INDEX/MATCH formula?


  • Michael Culley
    Michael Culley ✭✭✭✭✭

    You can use index/match with checkbox columns but I believe you are doing it incorrectly.

    You would want to do something like =INDEX({checkbox column},MATCH([unique identifier column]@row,{unique identifier on sheet with checkbox},0))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!