Summing cells with text and checkbox

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!

Find more posts tagged with

Accepted answers

Amanda Medina

Worked like a charm! Thank you!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.