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!