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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives