Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Subtract weeks for lead time with notifications
I'm trying to subtract 6 weeks from my Factory Shipment Date (row 1) to give me lead time to notify Port Authority which is assigned to someone on my team. I have 15 categories/columns like this with 4 team members. The categories need a lead time of 6 weeks, 4 weeks, 3 weeks, 2 weeks, 1 week or 3 days. This is for a huge project, trying to deliver 100 modular homes into NYC.