How to send a form triggered by a cell changing?
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.
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.