How to get IF check box is checked "Order" IF checkbox is unchecked "DO NOT ORDER" working???

mistone
mistone ✭✭✭✭
edited 01/25/23 in Formulas and Functions

I'm stumped. I'm trying to return a "ORDER" If a checkbox is checked and "DO NOT ORDER" if checkbox is unchecked on a reference sheet using index match. Unless I've lost mind I'm pretty sure 0 = unchecked and 1 = checked. I think this should be working,

When I use the formula below I get "ORDER" for INDEX/MATCHED cells that are both checked and unchecked, so I'm missing something...

=IF(INDEX({3.0 IR Sheet - Logi Email Col}, MATCH(Itinerary@row, {3.0 IR Sheet - Itinerary Col}), 0) = 1, "ORDER", "DO NOT ORDER")

Answers

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    I have 2 questions. First, is the content you're looking for on the first column? I might try a 1 as I'm not sure that the index is a 0 based function.

    Also, how is your list sorted on the referenced sheet? If it is not sorted in an ascending order, then your match won't work. If it is a not sorted list, then you need to add a 0 to the Match function. I would think your formula would look like:

    =IF(INDEX({3.0 IR Sheet - Logi Email Col}, MATCH(Itinerary@row, {3.0 IR Sheet - Itinerary Col}, 0), 1) = 1, "ORDER", "DO NOT ORDER")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!