Return a value of 1 if two boxes are checked

Options

Hello!

I am looking for the formula to return a value of 1 if two boxes in the same row are checked. Please see the example below.

If both boxes in DU and Scheduled are checked, the formula returns a value of 1. If only 1 box is checked, it returns a 0.

Any help is much appreciated!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!