Inconsistent Formula Function (seemingly, anyway)

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.

Find more posts tagged with

Sheets

Formulas

Comments

Andrée Starå

Hi Ben,

Is the formula supposed to look at the cells of other rows and not the current one it's on?

Have a fantastic day!

Best,

Andrée Starå - Workflow Consultant @ Get Done Consulting

Chak Khiam

Ben

Do you really want to point to cell in row 23 bolded below rather than 26?

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

Ben Donahue

Andrée, Chak,

No, no I do not. Thank you for pointing that out. Typical noob mistake, d'oh!

Thanks for the help!

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…