Using form buttom to edit row in sheet?

Ask for Help
3

Technically no, it’s not possible. But there may be a hacky way to do it. You could add a form button, pull in existing vision statement and user’s email, then provide an entry field to enter a new statement. This information will be submitted to a new sheet. Using the formula in the attached thread, you can pull the the most recent statement from the form response sheet and insert it into the user record. Unfortunately, I don’t think the formula is Arrayformulas friendly, so you would have to copy the formula down all of the user record rows.