Summing cells with text and checkbox

Amanda Medina

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!

Amanda Medina

Worked like a charm! Thank you!

Paul Newcome

Are you wanting to add together all of the cells in the [FSA Backlog] column, or are you trying to automatically generate the 1's in that column or are you trying to get a count of how many rows are "FSA" and the Backlog box is checked?

David Tutwiler

I believe these two formulas will get you going.

=IF(AND([request type]@row = "FSA", backlog@row = "true"), 1, 0)

=IF(AND([request type]@row = "Warranty", backlog@row = "true"), 1, 0)

Amanda Medina

Worked like a charm! Thank you!