Inconsistent Formula Function (seemingly, anyway)

Ben Donahue
Ben Donahue ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I wrote a formula to calculate the number of days until a task is due. It works perfectly most of the time, but, on some rows, it doers not. Below are the actual copied and pasted formulas from the cells that say "OVER-DUE" and "-2, referenced from the screenshot:

=IF([Task Total Hours]26 = 0, "", IF(Finish23 < TODAY(), "OVER-DUE", IF(Finish26 = TODAY(), "DUE TODAY", NETWORKDAY(TODAY(), Finish26))))

=IF([Task Total Hours]27 = 0, "", IF(Finish24 < TODAY(), "OVER-DUE", IF(Finish27 = TODAY(), "DUE TODAY", NETWORKDAY(TODAY(), Finish27))))

To me, it looks like I should get the exact same result from each, given that [Task Total Hours] is not equal to 0 in either case and Finish is the same value in both cases. What am I not seeing?

Thank you for your time and help.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!