IF, AND with NETWORKDAYS formula not working

JMT

I am trying to build an IF / AND formula with a networkdays calculation when true and "N/A" when false. I've tried many versions for over an hour and it is still unparseable. Any help would be greatly appreciated!

=IF(AND(Status@row = "Ready for Review",[Assigned To]@row = ""), NETWORKDAYS([Date Submitted]@row, TODAY()), "N/A"))

Thank you,

JMT

Jason Duryea

It looks you have one too many “)” in the formula. Remove the one from the end.

Jason Duryea

It looks you have one too many “)” in the formula. Remove the one from the end.

JMT

Brilliant! Thank you, Jason! It worked. 😃