Sumif column name contains "Tax"

Hi All,

I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals.

Basically, each column on the sheet has one employee's name and the dept that they belong in (read "John Smith - Tax" or "Jane Doe - Payroll").

What formula do I need to use to Sumif the column name contains "Tax", "Payroll", etc.?

Find more posts tagged with

Formulas

Community Platform

Accepted answers

Mike TV

@Kristina Feocco

Tax Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Tax", @cell), Score:Score)

Payroll Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Payroll", @cell), Score:Score)

Tax Total Score and Payroll Total Score should really be a Sheet Summary etc

All comments

Mike TV

@Kristina Feocco

Tax Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Tax", @cell), Score:Score)

Payroll Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Payroll", @cell), Score:Score)

Tax Total Score and Payroll Total Score should really be a Sheet Summary etc

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.