We have been thinking of creative ways to allow users to manage just what is their responsibility without the added risk of someone fat fingering a change to a row that they do not own and the question came up if there was functionality to pull up data for a row similar to a DB query?
We have users submit requests to our SMARTsheet via a form that adds a new row to our sheet and assigns a unique record ID to the row. We set up reminders and alerts for our users to update the data on a weekly basis, but at times end users know of changes between the weekly alerts and we'd like to encourage them to share those updates as they are available and not wait for the weekly update reminder.
Is there a way to have a form or report query a SMARTsheet and display data in the form or report based on the results? For example, a user would go to the entry form (or a report) and manually enter the tracking ID and trigger a search which would populate the form (or report) with the data that matches the ID entered?