NETWORKINGDAYS
I have the following conditions:
1) Planned Ship Date (9-25-19)
2) Actual Ship Date (9-11-19)
If the Planned Ship Date = Actual Ship Date, Result should = 0
If Actual Ship Date < Planned Ship Date, Result should be a negative number (This should be -10)
If Planned Ship Date>Actual Ship Date, Result should be a positive number
Please advise on the formula
Regards,
Answers
-
Hi,
Are there multiple dates for multiple ships? Are the dates only in 1 row?
Regards
Rainier
-
=if(Planned Ship Date = Actual Ship Date, 0, if(Planned Ship Date > Actual Ship Date,Planned Ship Date - Actual Ship Date, Actual Ship Date - Planned Ship Date))
I hope this helps.
Rainier
-
Yes only one row
-
-
This should work for you...
=[Actual Ship Date]@row - [Planned Ship Date]@row
-
=IF([Delivery - Planned]# = [Delivery - Actual]#, "0", IF([Delivery - Planned]# > [Delivery - Actual]#, [Delivery - Planned]# - [Delivery - Actual]#, [Delivery - Actual]# - [Delivery - Planned]#))
This formula did not include NETWORKINGDAYS. The formula did work if the Delivery Actual was less than the Delivery Planned but did work vise versa.
-
If this does not work, try switching the order of the dates...
=NETWORKDAYS([Actual Ship Date]@row, [Planned Ship Date]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!