Formula not populating certain rows
Hi everyone,
I'm seeing an issue where I have a particular formula that moves a date to the nearest business day if the original date lands on a weekend. However, when I drag the formula down the column, it will not populate certain cells. (This is actually apparent across the entire row). Would you know how to solve this?
Best Answer
-
I think the problem is that your IF statement only accounts for dates that fall outside of weekdays. You're only solving the TRUE side of the equation, if that makes sense. So what's happening is the formula is putting data in for all of the instances where the date needs to be adjusted, but doesn't know what to do if the date is a Weekday.
To fix this, I think you just need to move your next to last closed parentheses to right after the Holiday Range. The Workday only takes 3 parameters, so you should close it there and allow the last October Grant Date to be what you feed the false parameter of your IF statement.
Does that make sense?
Answers
-
I think the problem is that your IF statement only accounts for dates that fall outside of weekdays. You're only solving the TRUE side of the equation, if that makes sense. So what's happening is the formula is putting data in for all of the instances where the date needs to be adjusted, but doesn't know what to do if the date is a Weekday.
To fix this, I think you just need to move your next to last closed parentheses to right after the Holiday Range. The Workday only takes 3 parameters, so you should close it there and allow the last October Grant Date to be what you feed the false parameter of your IF statement.
Does that make sense?
-
This worked! Thank you, David.
-
Awesome!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 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!