Link Smartsheet to Outlook Calendar

Options
JackM98682
JackM98682 ✭✭
edited 07/04/24 in Add Ons and Integrations

Hello! I'm trying to figure out if I can link Outlook to Smartsheet and use Outlook to identify non-working days. For example, there is a formula for one of our sheets where we record a date, and two days later get a reminder. If this happens on a Friday, it will trigger on Sunday, but I'd like it to trigger on Tuesday by using the Outlook calendar to skip non-working days.

Answers

  • James Keuning
    James Keuning ✭✭✭✭✭
    Options

    If I was solving this problem I would bring in my dates as a one-time import into a sheet, and then reference that sheet using a formula, so if the date selected is one of the off days, the formula returns the next working day. Basically COLLECT all of the working days greater than this date, and return the MIN date.