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.


Charita Lucas
edited 12/09/19 in Archived 2016 Posts

I need to count the number of times the "Status" column = "Assigned to SCJ" and

the number of times a date appears in "NDA Signed" column in the same row.


Both criteria need to be met.



The "Status column is a drop down list.

The "NDA Signed" column is a date.


In the parent row, I added this calculation but it is not working.  I'm sure it's wrong :-(

Can someone please help?


=COUNTIFS(CHILDREN(Status7), "Assigned to SCJ", [2016-NDA Signed (mm/dd/yy)]7), "1"



This discussion has been closed.