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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!