Date Formulas for Specific Deliverables

I am trying to create a formula that will look at a product line column and then return a date based on the Production Completion date plus 2 days if it is product A and plus 3 days if it is product B. However I also need it to account for WORKDAYS as well.

Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 09/01/22 Answer ✓

    Hi @davidvcolorado

    After seeing how many different products you have, it may be easier to add a "Number of Days" Column. Then simply use the workday formula to use the "Days" to add to your "Date". You can filter each individual product when adding the days to make it easier, then apply this formula.

    Here's another example I created for you:

    =WORKDAY($Date@row, Days@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!