Automated reminders
I'd like to set an alert/reminder for the Submitted User when a task is not met within our dashboard.
I created the following columns "Date Submitted" "Submitted by" and "Personal Charges Paid (Y/N)".
The logic reads: if "Personal Charges Paid" is marked "No", a reminder/alert is sent to " Submitted by" 2 days after "Date Submitted".
The reminder templates require a set date which isn't conducive for what I'm looking to accomplish since dates vary.
I'd like to create a formula, since none of the reminder/alert templates work for what I'm trying to achieve.
Best Answer
-
Assuming that your column are configure as followed :
"Date Submitted" -> Date
"Submitted by" -> Contact list
"Personal Charges Paid (Y/N)" - Check box
Beware that it will send a reminder everyday after the 2 days delay.
You can add a column that record the date when you send the reminder and evaluate if another reminder must be sent.
Answers
-
Assuming that your column are configure as followed :
"Date Submitted" -> Date
"Submitted by" -> Contact list
"Personal Charges Paid (Y/N)" - Check box
Beware that it will send a reminder everyday after the 2 days delay.
You can add a column that record the date when you send the reminder and evaluate if another reminder must be sent.
-
Hi Christian, thank you for your help! This is exactly what I was looking for!
-
Hi want to send automated reminders when the form is submitted to the assignee to approve or decline the request.
i want this reminder to be sent out till the status is submitted
-
Hi want to send automated reminders when the form is submitted to the assignee to approve or decline the request.
i want this reminder to be sent out till the status is submitted
-
Hi @Shwetaic
I hope you're well and safe!
Can you add a helper column with a checkbox or similar where the submitter can indicate they are done?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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