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
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives