Result from NETDAYS formula is a (-) value instead of positive value
Rick Girard
✭✭✭✭✭
I created this formula (with the Communities help, thank you) , the result of the NETDAY looks correct but I am getting a "-" in the number column. Is this a placement issue with the NETDAY function?
I tested the function in a separate sheet and it works properly I get the correct count and value (28):
=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), NETDAYS([Date Date]@row, TODAY()))
When I inserted and modified the string to reflect the columns in my Production sheet I get a result but with a '-' in front of the number (-28)
=IF(OR(CONTAINS("Stage 1", Stage@row), CONTAINS("Stage 2", Stage@row)), NETDAYS([Close Date:]@row, TODAY()))
Answers
-
-
I'll be checking it later today, thank you for your fast reply Kelly!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!