Column formulas

I need to subtract two days from an end date@ row and exclude weekends and holidays. Can I use this formula and incorporate the -2 days somehow? NETWORKDAYS(start_date, end_date, [holidays])


Thanks,

Best Answer

Answers

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    I would use =WORKDAY([End Date]@row, -2). You'll need to add a Holiday column but can use that to exclude those as well.

  • Ron Erdeljac
    Ron Erdeljac ✭✭✭✭

    Thanks so how would the Holiday formula work? =WORKDAY([Holiday]@row ???)

  • Ron Erdeljac
    Ron Erdeljac ✭✭✭✭

    I appreciate the prompt assistance!!

  • Ron Erdeljac
    Ron Erdeljac ✭✭✭✭

    Realized one more issue when using =WORKDAY([End Date]@row, -2) as my column formula.

    Let me provide context. This is a calendar creation using column formulas in the grid view and workflows to manage notifications to specific people 2 days prior to the event. Issue is... if a form entry event submission is for tomorrow the -2 days from the end date does not send the notification. How can I adjust the column formula or workflow to send the notification when <= 2 days from the event? Ty

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!