Link Smartsheet to Outlook Calendar
JackM98682
βββ
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
-
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.
