# How can I tick a box based on two criteria?

Options

I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them?

=IF([Checkbox]@row = 1, 1,0)

Tags:

Options

I think I found my own answer - FYI for anyone who has the same query:

=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

• ✭✭✭✭✭✭
Options

Your formula would look like this:

=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)

Sample:

Hope this helps, but if you've any problems/questions then let us know!

Options

I think I found my own answer - FYI for anyone who has the same query:

=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

• ✭✭✭✭✭✭
Options

Your formula would look like this:

=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)

Sample:

Hope this helps, but if you've any problems/questions then let us know!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!