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.

Count number of rows

Ashveer Surujdeen

Ashveer Surujdeen ✭

10/18/16 edited 12/09/19 in Archived 2016 Posts

I have a sheet that has a status column which is a dropdown list - In progress, not started and complete.

I want to return the number of rows where status is not complete.

How do I do this?

Tags:

Formulas

0 ·

Comments

Matt Hines ✭

10/18/16

=countifs([Status]1:[Status}100,<>"Complete") Should do it. Where 1:100 is the range. "<>" is "not equal".

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Smartsheet FORM Dropdown List - Cells in Column "have values that aren't dropdown values" Error
Hello All, Specifically for the Form's Dropdown List - what does it mean when I get this error message for a list that has 87 (manual, ugh) entries? —> (14 cells in (form) column) "have values that aren't dropdown values." Are there any special characters that aren't allowed, maybe? What are the rules for text to be valid…
Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…