How to send a form triggered by a cell changing?

Options
Bladerunner
Bladerunner ✭✭
edited 12/09/19 in Smartsheet Basics

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.

Tags:

Comments