Calculating days past due when comparing two columns
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
-
-
I'm still getting an unparseable error
=IF(ISBLANK([Revised Release Date]@row), IF([Planned Release Date (baseline)]@row < TODAY(), NETWORKDAYS([Planned Release Date (baseline)]@row, TODAY(), ""), NETWORKDAYS([Planned Release Date (baseline)]@row, [Revised Release Date]@row))
-
Try this...
=NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date - Baseline]@row), $today$1)
-
Paul - it is still saying Unparseable..I removed the "- Baseline" in the one column heading in case that was causing a problem and still getting the error
-
=NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date]@row), $today$1)
Do you have a column called "today"?
-
No...
-
So I replaced the $today$1 with the TODAY function and I believe it is now working
-
That would have been it then.
$today$1 refers to a specific cell in row 1 of a column called "today". If you do not have that, then you would need to use the TODAY function.
Glad it is working for you now. Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!