Update Request which create a new row

benolecl ✭✭✭
edited 12/09/19 in Formulas and Functions

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!