Smartsheet - trigger form

Hello,

I'm trying to trigger a form/ request for an update, however, I'd like the update to be requested from a user aka cell/ contact within the sheet.

Scenario:

I have an employee list (sheet) with the following columns: Name, email, date of hire, position (filled from another report outside Smartsheet). Based on a checkbox column > I'd like to trigger a request an update/ form to those listed in the sheet itself i.e. column - email, to 1. Confirm their employee id (column) 2. select a reward from a dropdown (column). Once they submit their responses, there will be a request for approval. I'd like the responses and approval status to be captured in the same spreadsheet, corresponding rows.

Is it possible to request an update from an email within the sheet itself OR what options do I have?

HELP! Tia

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!