How to use form to update a row of data?

Ref2335

New to using Smartsheet. We have a requirement to create a smartsheet form to intake information and periodically update that row of data over the course of months/years.

A given row is unique based on a drop down value where no 2 rows will have the same drop down value.

We are struggling to use the form to select an existing drop down value and see the existing data from the row.

Can a form be used in this way to update a row of data? If so...how, or what are the alternatives?

Jaime M.

Hello!

Using a form will only allow you to add a new row, not to edit an existing row. I would suggest using a dynamic view for updating rows. An example is below.

Here an employee can submit a new request via a form (or they can also submit a new request via the dynamic view if you select this option), and go back into the dynamic view to edit the start date or end date as needed. You can make any of the fields required or view only (such as the total days off count, which is a formula and is unable to be edited in the dynamic view).

You can also create a dynamic view off of a filter in a sheet. For the example below, you may want to only show upcoming time off requests, not those that have already occurred.

Additionally, you can create a report from multiple sheets, then use that report to create a dynamic view where individuals can update the information from multiple sheets in one place.

Hope this helps!