Count Formula

Kim Michael

My goal is to determine how many lines in a schedule that are actual task lines (not milestones). So I would need to count any line with the following criteria

"Status" is listed as: Not Started, In Progress, or Complete

"Assigned To" contains a name (or is not blank).

Thanks for any assistance

Paul Newcome

Give the COUNTIFS function a try:

https://help.smartsheet.com/function/countifs

Kim Michael

Thank you but I am still struggling on how to write out the formula.

Paul Newcome

What have you got so far, and what error message or output are you getting?

Kim Michael

This is what I have: =COUNTIFS([Status]:[Status], <> “”, [Assign To]:[Assign To], <> “”) and I get a error of #Unparseable

Paul Newcome

See how your quotes are slanted, but the "quotes" in this comment are straight up and down? The slanted ones are called "smart quotes" which (ironically enough) are not recognized as valid characters in Smartsheet. Try retyping them directly in the sheet or in a text editor such as Notepad (not Word).

Kim Michael

Tried the change but no luck. Although that was very good to know

 =COUNTIFS([Status]:[Status], <> "", [Assign To]:[Assign To], <> "")

Paul Newcome

What are the exact column names being used in your sheet?

Kim Michael

Status

Assign To

I want that line to be counted if both those cells in those columns are not blank

Paul Newcome

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

Kim Michael

Thank you so much for taking the time to try to help me.

Paul Newcome

Your column name is "Assigned" with the "ed" on the end. You have to make sure the column names in the formula match exactly what you have in your sheet.

Kim Michael

Thank you so much! Problem solved.

Paul Newcome

Happy to help. 👍️