Checkbox if 2 Criteria Met from Different Sheet

Frank S.
Frank S. ✭✭✭✭✭✭
edited 10/04/21 in Formulas and Functions

What am I missing:

I have a date and time from a master sheet, if both match want the checkbox in a second sheet

I can get the the formula to work if separate but when I tray and combine they do not work

Date Check Formula: check box works

=IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", 1, 0), 0)

Time Check Formula: check box works

=IFERROR(IF(INDEX({Test Range 3}, MATCH(Time1, {Test Range 3}, 0)) <> "", 1, 0), 0

When I combine the checkbox is not checked and should be:

=IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)), IF(INDEX(Test Range 3}, MATCH(Time1, {Test Range 3}, 0)) <> "", 1, 0)), 0)

Should I be using AND, if so, any help on how to combine them?

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

Tags:

Comments

  • Frank S.
    Frank S. ✭✭✭✭✭✭

    Found a Solution! :)

    Here is the formula I was able to get to work:

    =IFERROR(IF(AND(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", INDEX(Test Range 3}, MATCH([Meeting Time (8-10)]@row, {Test Range 3}, 0)) <> ""), 1, 0), 0)

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!