Incomplete Tasks Count Multiple Criteria

Shalaeha McClintock

I am trying to account for the number of incomplete tasks for Symbol column types.

For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post https://community.smartsheet.com/discussion/6552/countif-rows-meets-multiple-criteria.

=COUNTIFS([Checkbox Column]:[Checkbox Column], = "false", [On Target Incomplete]:[On Target Incomplete],"Green")

I am currently getting an #UNPARSEABLE error. Any help and advice on this would be greatly appreciated!

Thanks!

Andrée Starå

Hi Shalaeha,

You don't use "false" because Smartsheet will read that as text.

You also don't need the = sign before false. If you want, you can use 0 or 1 for false and true instead.

Try something like this.

=COUNTIFS([Checkbox Column]:[Checkbox Column]; false; [On Target Incomplete]:[On Target Incomplete]; "Green")

The same version but with the below changes for your and others convenience.

=COUNTIFS([Checkbox Column]:[Checkbox Column], false, [On Target Incomplete]:[On Target Incomplete], "Green")

Depending on your country, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer! 

Shalaeha McClintock

@Andrée Starå unfortunately that didnt work for me. I've had many issues troubleshooting these types of formulas, as they never seem to work! I've copied and pasted this into my row and am still getting the Unparseable error

Jayesh Nathani

Hi Shalaeha,

Could you please share screenshots and please let us know the type of column in which you are pasting the formula.

Andrée Starå

@Shalaeha McClintock

Can you paste the exact formula you used and also a screenshot?

Shalaeha McClintock

@Andrée Starå @Jayesh Nathani here is a screen grab of the formula, as well as the formula itself. The formula itself is different than whats above, as i simplified it for the sake of the question. This is just a regular text/number column, which is how all of my working formula utilize.

=COUNTIFS([Management Op Rhythm Tracker Range 2 Priority]:[Management Op Rhythm Tracker Range 2 Priority], false, [Priority incomplete]:[Priority incomplete], "High")

Screen Shot 2020-02-10 at 3.56.54 PM.png

Appreciate the ongoing help on this. Its been a pain trying to figure this out!

Jayesh Nathani

Hi Shalaeha,

Does your sheet have "Management Op Rhythm Tracker Range 2 Priority" column? or are you trying to reference any other sheet?

Looking at your screenshot, it seems the column name is incorrect, would you double check the name? or if possible share the sheet?

Thanks,

Jayesh

Andrée Starå

@Shalaeha McClintock

Happy to help!

It looks like you're trying to reference another sheet with the Management Op Rhytm. . . Range.

I'm not sure what you want to do so I agree with Jayesh.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)