Using a conditional statement with Index/Match for a checkbox column

Jennifer Kurtz

Hi!

Wondering if anyone can offer some help on a formula I'd love to get working in my sheet: I have a checkbox column that should be checked or unchecked based on information in another sheet.

My Sheet 1 includes a column for an organization name (LEA Name) and the checkbox column.

I need to reference Sheet 2: match the organization name, see if a "Math 1" column has anything in it (i.e., it's not blank). If the Sheet 2 "Math 1" column has a value, I want the box checked on Sheet 1. If the "Math 1" column is empty, i would like the box remain unchecked.

So far, using Index/Match and IFERROR, I've achieved the second part - keeping the box unchecked when "Math 1" is empty:

=IFERROR(INDEX({Math 1}, MATCH([LEA Name]@row, {Survey LEA Name}, 0)), 0)

However, I can't figure out how to tell Smartsheet to check the box when there IS a value in Math 1. (Presently, it's just pulling in the value of that cell - as you'd expect!) I'm at a loss on what function(s) to add and in what order. ...While I could use some workarounds, I'd like to learn how to make this work if possible.

Thanks for any help you can give. (I enjoy playing around with these formulas but I'm out of my league here!)

Bassam Khalil

Hi @Jennifer Kurtz 

Hope you are fine, could you please supply a screenshot for the tow sheet ( remove any sensitive data ), the formula you need to use is something like the following but i need the screenshot to design the exact formula for you.

=IF(ISBLANK([Math 1]@row), 0, 1)