Days remaining


I need help with my formula. It is only calculating if there is a completed date entered in the cell. I need it to calculate the number of days remaining and or number of days past the deadline, and I need it to show the calculations once a completed date is entered.

IF(ISDATE(Deadline@row), NETWORKDAY(Complete@row, Deadline@row), NETWORKDAY(TODAY(), Deadline@row))

Columns: Days Remaining, Task, Status, Deadline, Complete

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!