NETDAYS failure
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
Comments
-
Try changing the Days under Load column properties to Number/Text.
-
I second Brian's suggestion. The #Date Expected error is indicating that that column type expects a date returned, not a number. Changing that to text/number column type should resolve the issue.
This is a great resource for troubleshooting errors: https://help.smartsheet.com/articles/2476176-formula-error-messages
-
I used to use this all the time. I've since written many an error into formulas, so now I only need to refer back to it occasionally. Haha
-
Thank you everyone, that worked. Super confusing. #DATE EXPECTED to me suggests the column should be formatted for date...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.9K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!