Update Request which create a new row
Looking to have an update request that would create a new row (much like a form would do). Here is the situation:
- Row with Project Name, PMs, etc... A PMs has more than 1 project.
I need to calculate the weekly hours for stats purposes. If I use a form, the PM must submit it and then click back on the email again and submit again (as many time as projects he has) whereas the update request there is a "next" button.
An alternative would be to copy the content of the rows to the bottom of the sheet before the update request is sent but this would have to be done automatically.
Anyone has a clever suggestion?