Calculating days past due when comparing two columns

Options

So I am trying to compare two columns. 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.


I've tried this formula as I thought my logic was correct:

=IF(ISBLANK([Revised Release Date]@row), IF([Planned Release Date (baseline)]@row < $today$1, NETWORKDAYS([Planned Release Date (baseline)]@row, $today$1), ""), NETWORKDAYS([Planned Release Date (baseline)]@row, [Revised Release Date]@row))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!