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

Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?
Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…