Comparing 3 columns, one of which is a checkbox and returning days since.
If Already Released? checkbox is checked, return nothing ELSE 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.
=IF(ISBLANK([Already Released?]@row, 0, NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date (baseline)]@row), TODAY())))
I'm getting an incorrect argument error and I think it is where I'm joining the If Already Released? ISBLANK statement withe the NETWORKDAYS statement
Best Answer
-
Hi @sbrelage
=IF(ISBLANK([Already Released?]@row), 0, NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date (baseline)]@row), TODAY()))
You just forgot to close the ISBLANK Function with a ) :)
Hope it helped
Answers
-
Anyone have any good ideas on how to fix this formula? I know I am close but, again, think I'm missing a , or () between the ISBLANK and NETWORKDAYS statements
-
Hi @sbrelage
=IF(ISBLANK([Already Released?]@row), 0, NETWORKDAYS(IF([Revised Release Date]@row <> "", [Revised Release Date]@row, [Planned Release Date (baseline)]@row), TODAY()))
You just forgot to close the ISBLANK Function with a ) :)
Hope it helped
-
David,
That fixed the formula but I must have something wrong then in my logic. What I would like it to do is if Already Release? is Checked return a 0 value in my column. The column is tracking how many days past due the release is and I don't want it to keep tracking the days if the the software has been released...
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!