Formula for workdays based of category and start date
Hey there. I'm working on building on a sheet for the following:
I need a formula that generates and order date based off of category and start date. (ie If its a "Pool" category, and construction date of "2/1/23", I need a formula that populates an order date that is 10 business days before the construction date.
There will be different categories with different lead times (ie Some will be 20 business days, some 5 business days, etc)
I'm working with IF functions and Workdays but haven't quite been able to put it together. Would love any suggestions you have! Thanks!
Answers
-
The below should work.
=Iferror(IF([Item Category]@row = "Pool", WORKDAY([Construction Start Date]@row, -20), IF([Item Category]@row = "Appliances", WORKDAY([Construction Start Date]@row, -10), IF([Item Category]@row = "Accessories", WORKDAY([Construction Start Date]@row, -5), ""))),"")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!