Sheet Summary COUNTIFS using netdays

Jenifer Salvetti

I am trying to count how many requests are open for more then 2 days in sheet summary.

The above formula results in #UNPARSEABLE

Heather Duff

Hi @Jenifer Salvetti ,

Try this:

=COUNT(COLLECT([process engineering approval]:[process engineering approval],"",[days to complete]:[days to complete],>2))

This will count all of the rows that have been open for more than 2 days and the approval is still blank.

Hope this helps! Let me know if it works for you.

Best,

Heather

Jenifer Salvetti

Hi @Heather D ,

The formula is retuning 1.

I am also looking to exclude the weekend.

Thanks

Heather Duff

@Jenifer Salvetti Does your Days to Complete column exclude weekends? If not, you can insert a new column (or change your formula in the Days to Complete column):

=NETWORKDAYS([date submitted]@row,TODAY())

Based on your screenshot above, there's nothing that meets the criteria you listed.

Jenifer Salvetti

@Heather D

The days to complete column has =IFERROR(NETDAYS([Date Submitted]@row, [PE Change Date]@row), "")

I'm looking to count the requests that have no approval status and have been open for more than 2 working days.