Form completion populating in a sheet

Options

Hi! I am attempting to figure out how to have a box checked on a sheet once a form is completed. Can anyone point me in the right direction?


Thanks!

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @CMPeterson2013

    If you mean check the box when the form is submitted, you have many options. You can look for any required field in your form to be not empty. If you don't have the system columns Row ID, Created or Created By - any one of these could also be used.

    =IF([the column you choose]@row<>"", 1)

    Edit the formula above to either a field that is required by the form, or any of the above mentioned system column names that you have in your sheet.

    Does this work for you?

    Kelly