Date Formulas for Specific Deliverables

davidvcolorado

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.

=Chris Palmer

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)

=Chris Palmer

Hello @davidvcolorado

Based on your description I tried to replicate this in my own Smartsheet.

The formula I used is:

=IF(CONTAINS("Product A", Product@row), WORKDAY($Date@row, 2), IF(CONTAINS("Product B", Product@row), WORKDAY($Date@row, 3)))

I have provided a screen shot for your reference.

To replicate this make sure to edit any Column Properties that contain a Date, and set the Column Type as a Date.

Let me know if this helps.

davidvcolorado

Thank you Chris, that seems to be working perfect. I sure appreciate the help and the quick response. I did want to make this a Column Formula but I am getting an syntax error. Any thoughts on how to correct that?

Here is my final formula. It works great other than the cell limitations.

=Chris Palmer

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)

davidvcolorado

Thank you so much Chris.

=Chris Palmer

https://community.smartsheet.com/discussion/comment/342521#Comment_342521

Absolutely!

Happy to help.