Report Filter to show just current activities
This may be a dumb question, but I want to create an automated email that sends out a list of all activities that are currently in progress, not just something to flag upcoming due dates. I can't seem to figure out how to filter JUST what is going on presently. Any ideas?
Best Answer
-
Hi Mike,
When creating the Alert Someone workflow and setting the trigger to your "In Progress" status column, click on "customize message" and choose the option, "Links to sheet and specifics fields." Here you can specify which columns you want to include in the email.
A simple email would look like this:
Hope this helps.
Answers
-
Hi Mike,
When creating the Alert Someone workflow and setting the trigger to your "In Progress" status column, click on "customize message" and choose the option, "Links to sheet and specifics fields." Here you can specify which columns you want to include in the email.
A simple email would look like this:
Hope this helps.
-
Thanks John!Β That did the trick.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!