How can I tick a box based on two criteria?


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)

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

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!