COUNTIF calculation when a condition is met

Options

=COUNTIFS((Status@row,"DocuSign Approved"[Actual Completion]@row-[Target Completion]@row})

This is throwing an error. How do I calculate the Net work days between Actual Completion Date column and Target Completion Date column for only when the Status of the case is DocuSign Approved

Please help

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!