How to COUNTIF the NETDAYS between two dates is greater than 2?

hogobt

I have submitted date and completed date columns. I want to count a row if the days between the two dates is greater than 2 days. I am trying:

=COUNTIFS(NETDAYS([Submitted Date]@row, [Estimated Completion Date]@row), >2)

However, I continue to get "UNPARSEABLE".

If I do a dummy column and just do the NETDAYS formula above without the COUNTIF, it does calculate the days between. So I am not sure why I can get the countif to work when added. I want to avoid dummy columns.

Thanks!!

Jason Tarpinian

You are trying to write out an array formula, which is wonderful in Excel, but as far as I know, Smartsheet can't do… yet. So you are on the right track, you need a helper column that you calculate your NETDAYS() value, then do your COUNTIFS() off of that helper.