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.

Total count based on values from two columns

Reema Hussain
edited 12/09/19 in Archived 2016 Posts



I'd like to check the text in one column and a check mark in the second column and then get a total count based on that.


The first column is Scope which can be A or B. The second column is complete which is a checkbox that's either checked or unchecked. What I'd like the formula to do is check the Scope column. If it's A, then check if the the complete column is checked or unchecked. If it's both A and unchecked, those tasks need to be added so I know how many incomplete tasks there are.


Same for B. If the Scope is B and the complete column is unchecked, I'd like to add those tasks so I know how many incomplete tasks there are. 


This is what I have so far:

=SUM(COUNTIF(Scope:Scope, “A”), IF(COUNTIF(Complete:Complete, 0)))


If a cell in the Scope column is A, check the status of the complete column and get the sum if it's unchecked. I just realized that this doesn't check the Scope column for B. There's no If else statement in Smartsheet; any ideas?


Thank you,




This discussion has been closed.