Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

countIf for several values in same column

Jones

Jones ✭

09/28/17 edited 12/09/19 in Archived 2017 Posts

Hi - Newbie here, but how do you count several text values in the same column?

=COUNTIF(Status:Status, "Closed" OR "Deployed")

doesn't work

Tags:

Formulas

0 ·

Comments

SmSulli ✭

09/28/17

=COUNTIF(Status1:Status9, "Closed") + COUNTIF(Status1:Status9, "Deployed")

This will add any rows with "Closed" or "Deployed"

Make sure you adjust your range to the correct rows.

0 · Share on Facebook Share on Twitter
Jones ✭

10/03/17

ah. great.

easy when you know how!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.
Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…