How to send a form triggered by a cell changing?

Bladerunner

Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one of the cells. The form is created as a feedback form with fourteen questions and uses a simple 0-5 star rating drop down box. The questions relate to 14 additional columns in the same sheet which are unpopulated. How can I get the cell status changing to completed to automatically send the form, and that form to update the unpopulated columns on the correct line?

 

Many thanks.. Ben.

Andrée Starå

Hi Ben,

You'd use an update request thru automation triggered by the status changing to Completed.

Hope that helps and let me know if you need any help!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting