Help with IF/INDEX/MATCH (I think)


Hi there - I'm looking for a formula that looks at Sheet 2 and if the "Terminated" box is checked, then check the "Not Currently Active" box in Sheet 1, according to the entity name. (Meaning if Happy Co is listed as Terminated in Sheet 2, it would be marked as "Not Currently Active" in Sheet 1.

I appreciate any help you can offer!

Best Answers

  • Beth Fantozzi 1
    Beth Fantozzi 1 ✭✭✭✭✭
    Answer ✓

    I'm sorry but this didn't quite answer my question. And after I looked at it again, I realized that my question was wrong. I actually need to check the box "Not Currently Active" in Sheet 1 if the information in Sheet 2 is: "Terminated is Checked", and the state is X and the Entity Name is the same. Here are the new screen shots:

    Thank you!

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

    =if(has(collect({terminated},{entity name},[entity name]@row,{State of Filing},[State of Filing]@row),true),1,0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!