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.

COUNTIFS

Options
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"

Tags:

Comments

This discussion has been closed.