How can you set up a workflow to trigger on a variable date

In an onboading form for new hires, I want to set up a trigger to fire 160 days after the person's hire date but I'm not going to know what that is, so I can't use the date field to trigger because I'm being prompted to choose a date from my form.
I tried to trigger on the hire =date +1 day to see if that would work, but I can't leverage formulas in the automation.
Does anyone have any ideas how to trigger a workflow when you based on a future, variable date?
thanks
Michelle
Best Answers
-
Bassam,
Thank you! I think that's going to work. Good thinking. I'll let you know.
Michelle
-
Hi @Bassam Khalil & @Michelle Barnett
Quick note - the trigger here is set to when the "Hire Date" value is changed, but this will only change when the row is first created. This means there won't be anything to tigger the workflow once 160 days have passed, even though it meets the condition of this workflow.
You could either work within the Date Based workflow's days:
Or potentially using a Date Column with a formula in the sheet as the trigger for the workflow. Michelle, I answered your other post with my personal preferred solution, here.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
I'm trying that now. Thanks
Answers
-
Hi @Michelle Barnett
Hope you are fine, please try to add a helper column to calculate how many days passed since the hiring date till today call it "Days Passed After Hiring" and use the following formula as a column format formula to calculate:
=TODAY() - [Hire Date]@row
then use the following workflow to trigger the alert:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Bassam,
Thank you! I think that's going to work. Good thinking. I'll let you know.
Michelle
-
Hi @Bassam Khalil & @Michelle Barnett
Quick note - the trigger here is set to when the "Hire Date" value is changed, but this will only change when the row is first created. This means there won't be anything to tigger the workflow once 160 days have passed, even though it meets the condition of this workflow.
You could either work within the Date Based workflow's days:
Or potentially using a Date Column with a formula in the sheet as the trigger for the workflow. Michelle, I answered your other post with my personal preferred solution, here.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Yes, you're right, I couldn't get the workflow to send a message. I tried the other suggestion about the date column and that didn't fire a message either. I can't use the trigger you've documented above because it's too late. The alert has to go before 180 days.
-
I would suggest a date type column with
=[Hire Date]@row + 160
Then set up your workflow to trigger based on this date column.
-
I'm trying that now. Thanks
-
Great minds think alike, @Paul Newcome ! 😉
That's exactly what I suggested on the other post. @Michelle Barnett, this is the link to the other post if you want to see screen capture examples.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
It worked - Finally 😀 that was a lot hard than I thought I was going to be.
-
@Genevieve P Haha. I didn't even see that. Ugh.
-
Thank you all for your input on this. I appreciate your help.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives