How can I "count" with Business/Holidays if there are blank cells?
We are creating an Out of State(OOS) Request to Smartsheet. EEs can submit up to 3 requests at one time to work OOS. Some people only had 1 requests - meaning the other 2 requests are 0. How do I create a formula that calculates the days (Business days and excludes Holidays).
the 1st request (green) has 3 dates submitted - so number under "Count 1", Count 2, Count 3 work.
The 2nd request (yellow) submitted 1 request - so Count 2 & Count 3 are blank. But I still need it add total count.
How can I do that please?
Answers
-
I'd reformat your intake sheet/form for this - have each request get its own row, but limit them to having 3 open requests at a time; then you are avoiding the issue with empty columns. Otherwise, if you REALLY want to keep it spread across columns like this, just use some if statements to void out Count2 and Count3 as a function of your "Requests" column…so, wrap the function in Count2 like this: =if(requests@row>=2,(your current function here),0)
-
Thank you for your assistance. I would like to keep the option to have 3 requests. I tried adding your formula, but doesn't seem to work.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!