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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives