How to Have Formula Continue to Next cell When Dragged Down.
I am creating a delivery & install sheet. On the delivery sheet I have a column that is a date property, on the install sheet the correlating column is also a date property. I am using the workday formula, "(=WORKDAY({Exterior Delivery}, 1, {Holidays Range 2})". The problem is the function won't apply to the other cells when dragged down. It would be extremely tedious if we were to have to type the formula for every single install cell. I tried referencing the entire delivery column, but it just pops up as invalid data type.
Answers
-
you should be able to right click on the cell and choose convert to column formula
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
When I do that it only references the single cell from the formula. So the whole column is referencing one date, not converting to each individual date.
-
The issue is in how your trying to use the workday function.
the first portion of the work day function can not be a range. so if your using a reference sheet to pull dates. you would want the do the function there to create a column to reference.
how ever WORKDAY always counts sat and sun as non working days.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!