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?
I have also tried using a standard Request Update, and although that does allow me to send just the 14 new columns for the update, the column Name field is not large enough to take a full question. I have tried putting the question into Column Description, but that doesn't appear on the Request Update Form.
I have also tried to create a form and trigger that through an Action when the cell value changes, but I can't seem to be able to send a form in that way.
I would also add that it is not essential that the answers populate the same sheet, it could be another sheet, as long as I can take the Description field from the original sheet to cross-reference with, so yes I could send a link to a new form, but how would I get a reference to the row into that new form.
It's very frustrating, it seems to be almost possible...
Apologies if this appears more than once, the Community site went down while I was originally posting the question.
Thanks in anticipation. Ben.