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

edited 12/09/19 in Archived 2017 Posts

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. 


  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    If I'm understanding correctly, could you use something like this

    =[Factory Ship Date]1 - [Lead Time (Weeks)]1 * 7

    Then under notifications, use that column to email "Team Member" the reminder? For 3 days, your lead time weeks would have to be .5, I don't know another way around that.

    Jason Tarpinian - Sevan Technology

    Smartsheet Platinum Partner

This discussion has been closed.