How to create reminder workflow for activities in specific row?

Hi All,
Would like to know if possible to create reminder workflow for activities in one specific row (in header).
I want to set up an automated reminder for each activity to trigger when the Due Date is reached. Both activities and due dates are in row instead of column. And all dates are in text/number format.
Thank you in advance.
Answers
-
Hi,
Would it be possible to change the dates to dates format?
In that case you can set up a workflow running for each column, using When date is reached workflow.
Best,
Beata
-
Hi @SmartWay360
It's not possible to change the dates to date format because I have other rows with sub-activities, responsible person and timestamp.
Is there any other way to create the workflow?
-
Hi,
Will be the position of of the dates in each column in the same place (row/ column)? If yes, you can use DATEVALUE function. You will create helper column to transform the date in text format to date format. This than you can compare to the today date (TODAY() function). This could be used as a trigger for your notification. Will this work? If you have questions let me know.
Best,
Beata
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives