Networkdays when second date is empty
I'm trying to figure out how to get the network days when the second date column is blank. It should then just be 1.
I'm going crazy trying to figure it out.
Update: I am still playing with this formula. I've realized I just need an IFBlank formula. If blank, return 1.
My formula returns #Incorrect argument set
=IF(ISBLANK([PTO Date]4, "1"))
=IF(ISBLANK([PTO Date]4, 1))
=ISBLANK([PTO Date]4, "1")
=ISBLANK([PTO Date]4, 1)
Comments
-
Realized that I do need Networkdays and if no second date field is blank, return 1.
Thanks for looking!
-
SOLVED!
=IF(AND(ISDATE([PTO Start Date]2), ISDATE([PTO end date]2)), NETWORKDAYS([PTO Start Date]2, [PTO end date]2))
I was wrong, I don't want it to return 1, I need no amount to show.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives