triggering a workflow by a system date
I'm trying to trigger a notification based on Creation Date (auto-date) + 30 days. I hope I'm just being thick since I would think this to be a fairly common type of workflow. Unfortunately system date columns cannot be used to trigger a workflow, unless I'm missing something. At this point I think I need to create a helper column with a formula based on the Creation Date column. Thoughts on how to do this fairly basic workflow? Example formula for a helper column?
Best Answer
-
The formula for the helper column would be:
=DATEONLY([Creation Date]@row) + 30
Answers
-
I am trying to do the same thing and see there hasn't been a response to this. @Jim Bob Green, it looks like this is 10 months old - did you ever figure this out and/or get an answer offline? Thanks for any help you can give!
-
The formula for the helper column would be:
=DATEONLY([Creation Date]@row) + 30
-
Thanks Paul.
@BecH. I actually don't specifically recall how I got around this last year. I have a bunch of Smartsheets I work with and have long since moved on. I probably leveraged the relatively new Record a date workflow to more easily push the creation date into a helper column. That is an awesome newer Smartsheet feature that has saved me a ton of time. Regardless, Paul's answer is one that I'm saving in a little file I keep of helpful function examples.
Help Article Resources
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
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!