Can I use a form to complete cells in an existing row?

Dennis Elsbury

I have a project that requires and outside client to provide half the information.

I would like to just use the convenient update function, but there is a lot of logic built into the form I would like them to use and the update function doesn't seem to support logic.

Bassam Khalil

Hi @Dennis Elsbury 

Hope you are fine, i advise you to use Update Requests to send the specific cells that you want to be updated

Andrée Starå

Hi @Dennis Elsbury

I hope you're well and safe!

You could use another sheet for the client's form and connect that sheet with the main one using cross-sheet formulas combined with a VLOOKUP or INDEX/MATCH structure.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

Dennis Elsbury

Andrée

Thanks for the suggestion. I tried to Index/Match cross sheets. It worked when I entered the formula, but did not work in an automatic sense when I entered new lines?

Dennis Elsbury

I believe I got the INDEX/MATCH to work correctly. Thank you all for the help!!