Remove negative (- ) sign from a day count
Hello Community!
I am trying to write a formula to calculate net work days between estimated and actual completion dates, in this formula l have a condition to show as blank the Design Completion Days cell when there are no estimated/actual design completion dates. The formula is working but is showing the "-" sign, l don't care to see if the date is past due, but to see the total days it takes for the contractor to submit the design.
Screenshot with formula for reference:
Best Answer
-
The syntax for NETWORKDAYS is: NETWORKDAYS( start_date, end_date, [ holidays ])
The problem you're having is that in your formula you have the end date where the start date should be, so of course it's counting backwards! Your [Estimated Design Completion Date]@row should come before [Actual Design Completion Date]@row in your formula.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Try this formula and see if it works for you. You shouldn't need the helper columns to complete this process. .
=IFERROR(NETWORKDAYS([Estimated Design Completion Date]@row, [Actual Design Completion Date]@row), "")
-
Thanks @Jeff M. Still getting the negative sign next to the number:
-
The syntax for NETWORKDAYS is: NETWORKDAYS( start_date, end_date, [ holidays ])
The problem you're having is that in your formula you have the end date where the start date should be, so of course it's counting backwards! Your [Estimated Design Completion Date]@row should come before [Actual Design Completion Date]@row in your formula.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff R Good catch! That did it, thanks!
-
If someone finds this that is looking to count dates to either side of a center, you can use the ABS() function to find the absolute value as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!