Summing cells with text and checkbox

Options

Hello,

I am looking for a formula to add cells that include both text and a checkbox. Please see example below.

If Request Type is "FSA" and the box under "Backlog" is checked, formula return a "1". Similarly, if Request Type is "Warranty" and the box under "Backlog" is checked, the formula returns a "1".

Thanks again for your help! Being so new to Smartsheet, I feel like I would just run in circles without this resource!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!