Automated Update Request Form Changes
I have built a tasklist. It is set up with a grant name being the primary field. We do monthly update requests via a form request. The form request is going to the resource name for the grant task. When the resource name receives their request, the forms are in grant order and not due date order. We would like the automated update request to go out in a different order (due date) rather than by grant which is with sheet order. I could not figure out which automation step to use to do this.
Comments
-
My first suggestion would be to sort the sheet by due date order. If this does not work...
.
Move the Grant Task to a different column (I will call it [Grant Task] for this). In the Primary Column, use a formula such as this...
=YEAR([Due Date]@row + "" + IF(MONTH([Due Date]@row) < 10, "0") + MONTH([Due Date]@row) + IF(DAY([Due Date]@row) < 10, "0"), + DAY([Due Date]@row)
.
What this does is generates a number in a consistent format of yyyymmdd based on the due date. The sort is up to you whether ascending or descending. Your requests should now go out in date order as opposed to task order.
-
The forms are set up to go out as an automated update request. Is there a way to have the sheet sort automatically before it does the automated update request?
-
Not directly.
Will there be multiples of the same due date? If so, we will need to account for this as well before moving on to the solution for auto-sorting.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives