I am trying to get the highlighted formula to exclude weekend days.
The way the sheet is currently setup, each row is a different job. there are no parent or child lines. I am trying to set a milestone date from one department task to another. However, the formula doesn't seem to recognize or account for when dates fall on a weekend. 1/6/24 and 1/7/24 are both weekend days. How can i write this formula to do that? Thanks,
Answers
-
Try this
= workday([Target Completion: Design}@row,[Fabric ordered milestone]@row
-
that did not seem to work.
I get this error: "#incorrect argument set"
-
Hi @Jason L.
To correct the incorrect argument set error
- The } in the formula should be a ]
- The formula needs a ) at the very end
However, I am concerned it might not work for you as your milestone column looks like it might be a duration column and the workday function needs a number - ie 1 rather than 1d. You may just see an invalid data type error instead.
Have a try, and let us know what happens.
-
I changed the all the "Milestone column" from a duration to a text/number column type. Then i tried adding workday to the formula like this: =WORKDAY([Target Completion: Design]@row + [Fabric ordered milestone]@row)
I am now getting #INCORRECT ARGUMENT SET.
-
Hi
You have swapped the comma for a plus sign. Try
=WORKDAY([Target Completion: Design]@row, [Fabric ordered milestone]@row)
-
I believe I figured out my own issue. After playing around with the formula, I got it to work. I don't fully understand why it worked but here is the new version of it:
=WORKDAY([Target Completion: Design]@row, [Fabric ordered milestone]@row)
I needed to add a "comma" after the first "@ROW" and then remove the "+" from between the date columns. It now is accounting for weekends and holidays. If anyone can explain why this works i would love to know. Thanks.
-
Yes, somehow in correcting the issue with the wrong type of } and the missing ) you replaced the comma with a plus sign. The syntax for the WORKDAY function is the date then a comma then the number of days to add to that date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!