Comparing 3 columns, one of which is a checkbox and returning days since.
If Already Released? checkbox is checked, return nothing ELSE If the Revised Release Date is blank, then look at Planned Release Date -Baseline and determine how many working days we are past due. If Revised Release Date is not blank, use that field to determine how many working days we are past due.
=IF(ISBLANK([Already Released?]@row, 0, NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date (baseline)]@row), TODAY())))
I'm getting an incorrect argument error and I think it is where I'm joining the If Already Released? ISBLANK statement withe the NETWORKDAYS statement
Help Article Resources
Check out the Formula Handbook template!