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()))

Kelly Moore

Hey @Rick Girard

I answered this in your other post.

https://community.smartsheet.com/discussion/94767/using-the-or-function-to-select-a-fixed-value-in-a-cell-that-contains-specific-characters#latest

Did it work for you?

Kelly

Rick Girard

I'll be checking it later today, thank you for your fast reply Kelly!