How to auto-check a checkbox based on a checkbox from a different sheet?

edited 01/17/23 in Formulas and Functions

I tried using If(COUNTIFS..) formula but it's not working. How can the results from the checkbox be transfered to a new sheet using a formula? Thank you


  • Samuel Mueller
    Samuel Mueller Overachievers
    edited 01/17/23

    @TMK_99 probably need a lot more information but you could try instead

    =if(countifs(...)>=1, 1, 0) that would check your box if the countifs matches any criteria.

    Assuming you know how to use cross sheet references

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!