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

Character Limit Formula
I'm unable to convert this to column formula (probably due to the reference to my 'blank' column… However, this formula doesn't work, =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID Limited to 20 VARCHAR", "") So, I changed it to this, which works… =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID…
Testing Table View with over 20k rows
Hi, I'm trying out some proof of concept stuff for a solution that will have over 20,000 rows and needs to interact with the sheet in Table view. I've used DataShuttle to put in the rows, I was able to open the sheet in Table view once, but then I tried going back to grid view and just get this error message. Problem is…
Development Environment for Production Change Development
Hi all, I have a solution that I've pushed out to production but now there are changes being asked for. I've duplicated my workspace as a way to build out and test changes safely. As I'm beginning to work thru solving the changes in this duplicate/dev environment I'm seeing the amount of time and potential for error it…