How can I subtract a changing number of days from a date?

Hi there,

I have a "Due Date" column and an "Order By Date" column. The Order By needs to reflect a date that is the Due Date minus our lead time (reflected in a third column and listed as a number of days). The issue is that the lead times change and vary from product to product. So I'm trying to create a formula that takes "Due Date" - "Lead Time" = "Order By". I'm hoping this is achievable?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!