nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

adding multiple values together

ShaunW

Hi, i am trying to build a table where i have to add multiple criteria such as "Not Started", "In Progress", "On-Hold", if i use this formula =COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, "In Progress") it works fine but if i add the search in for the other criteria is seems to zero out the previous calculation, =COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, "In Progress", {IRM SOW #13 - RAID Log Range 1}, "Not Started")

タグが付けられた投稿をさらに検索

Accepted answers

Paul Newcome

That is because the COUNTIFS function basically uses an AND function on the back-end. Your above formula is basically saying to count where the cell equals "In Progress" and "Not Started" at the same time which is not possible. You are going to need to incorporate an OR function like so:

=COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, OR(@cell = "In Progress", @cell = "Not Started"))

All comments

Paul Newcome

=COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, OR(@cell = "In Progress", @cell = "Not Started"))

ShaunW

This was great, many thanks it worked first time 😁

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

クイックリンク

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.