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!