How can make MS Team reminder at exactly point of the day by input on Smartsheet?
Basically, I am looking for a solution to build a reminder via MS Team bot. The employee will input a particular time on Smartsheet cell ( by "time" I meant: 15:00 04/07/21, 7:30 07/04/21..... the exact date time), then at that point of time, Smartsheet will automatically send a reminder via MS Team bot.
I am not sure if Smartsheet can help with the exact time, since mostly I can only interact with " created, finished, changed" time....
Please help me verify if there is a way to do this
Answers
-
Hi @Vu Nguyen
There isn't a direct way to do this where one workflow can read time in a cell and then automatically use this as an indicator for when to send an alert to Teams.
However, if you have a pre-set list of times for your users to choose from (perhaps from a dropdown list), you can set up multiple workflows (one for each time) to send out at a specific hour.
See: Create a Time-Based Automated Workflow
In this instance you would set up Condition blocks to only send this specific alert if 7:00 was selected. You could also add a condition that the date the row was created is Today, or some other criteria using a Date. Let me know if you'd like to see screen captures of what I'm describing. Would this work for you?
Another alternative may be to look into using a third party application, such as Zapier.
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives