Need Help With COUNTIFS OR Formula.

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress")

That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the provided screenshot, the number would be 3.

I would like to amend the above formula by adding an OR so that the formula counts the number of cells that columns that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also having either "In Progress" or "Pending Start" in the System Status column. Based on the provided screenshot, the number would be 4.

Find more posts tagged with

Formulas

Sheet Summary

Conditional Formatting

Accepted answers

Nic Larsen

Try:

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], OR(@cell = "In Progress", @cell = "Pending Start"

All comments

Nic Larsen

Try:

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], OR(@cell = "In Progress", @cell = "Pending Start"

SmarsheetNewb

https://community.smartsheet.com/discussion/comment/422915#Comment_422915

Thank you Nic. That worked.

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.