Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Recurring Workflow
Greetings all,
I am trying to create a workflow that will send me a notification every 28 days from a date in a specific cell (Start Rent). I want this to continue every 28 days until a date is listed in another cell in that row (Stop Rent). The purpose is to notify me that a Rent Cycle Bill is due for each project. Any help would be appreciated. I included a snip of what the rows look like in my sheet.
Answers
-
You would set your trigger to be date based then select "Custom" instead of "Run Once". You would set it to run every 28 days here.
Then you would include a two part condition of the [Start Rent] field being in the past and the [Stop Rent] field being in the future.
-
Thank you. It is not working though. I think the issue may not be the conditions though. I set a workflow to send me an email when Start Rent is changed to Any Value so I can test it. And it is not sending any emails. Any suggestions?
-
Have you checked your personal settings to make sure they include changes made by you?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
