Formula for workdays based of category and start date

Options
babasmith
babasmith
edited 01/03/23 in Formulas and Functions

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!


Tags:

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    edited 01/03/23
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!