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.
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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))))
-
Andrée, Chak,
No, no I do not. Thank you for pointing that out. Typical noob mistake, d'oh!
Thanks for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!