Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Can you set up an automatic update request to be sent to a person at the start, mid point, and finish date of an assigned task?
You cannot schedule them based on aspects of the sheet/row (such as dates) but you can schedule them manually for certain dates or recurring till a specified date.
Mark,
As a work-around, since you can't schedule Update Requests that way, but you could at least send Reminders.
A Reminder can be set up on a specific column date and trigger in several different timeperiods before, on, or after the date.
That would take care of your start and end reminder.
For the mid-point, create a new Date column for the Mid-Point date.
Use a formula to calculate the mid-point date.
Something like this would work for row 23
=WORKDAY([Start Date]23, INT(Duration23 / 2))
The INT() takes the duration (the work-days between start and end date), divides by 2 and rounds down.
The WORKDAY function adds that value to the Start Date.
Depending on how you want to calculate the mid-point date and how exact you want to be, there are other ways to determine it, but this will get you with a day of the mid-point by work-days.
Hope this helps.
Craig
Great suggestion, J. Craig. Thank you.
