Form completion checking box in sheet

CMPeterson2013

Hi!

I am attempting to have a box checked on a sheet after a linked form is completed. I have a established columns with a persons Name and want to have a column that has a check box when a specific form is completed by that person. However, the wall I am running into is that I a m having a duplicate row of information populate with the checkbox. So therefore I have a row with the persons name and an unchecked box as well as a row with the persons name and a checked box. How would I automate the removal of the duplicate?

Thank you!

Smartsheet User 99

If you have a column with names already established, are the names being brought in from a different source like a master attendance roster?

Andrée Starå

Hi @CMPeterson2013

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

CMPeterson2013

I have a sheet for my volunteer organization, where a row has been entered with the volunteers, name, contact info, etc.

There are several forms we have our volunteers fill in as part of their verification process. I would like to have a column added to the individuals row for each form they have to fill out, and once the form is completed, would like that column to be checked.

Currently, I am having a duplicate entry once the form is completed. It is creating a NEW row with the volunteers information and adding the check for the form completion.

Thank you for your help!