keeping all responses from monthly update requests

Jamie Kenealy

I need to get some data from a partner every month. I have set up an update request to be automatically sent for that time frame, but I'm wondering ...does it add another row every time they respond to the update request? Or, when they respond to the automated request, does it overrun what was they had previously submitted and only keeps the most recent update? 

I want to have a year's worth of monthly data readings at the end of this, so I want the data from each month's update request to be stored in my sheet. Can I do this by just having the one update request that automatically repeats monthly? Or do I have to do separate update requests for each month?

Mike Wilday

Update requests overwrite the row. I would suggest using a form. You could send them the link to the form each month and then that would add a new row. 

https://help.smartsheet.com/articles/522221-using-web-forms