Add form response to a cell rather than to a row

John Michael (Mike) Munsil

Is there a means to add form response to a cell rather than add a new row?

Context:

We have an existing Google Sheet that we share with all staff, and as they receive new assignments they are required to update the Daily Forecast with the relevant information. They do that manually into individual cells (which turn green when there is data in them). See below:

This Google sheet has a year's worth of daily columns and about 100 staff rows. The current date automatically is marked in red at the top of the sheet. The staff member just goes to the cells of interest and enters their information.

Goal:

To do this via a Smartsheet form rather than manually.

I can and do have staff add info to a weekly summary using a form, and their entries occupy an entire row.

Is there a way for me to have information from a form entry go to a cell or range of cells (range based upon staff name and dates range)?

Certainly I can have a form add rows to a Gantt chart but the boss wants the format that I created above in Google Sheets, as it is intuitively easy to use. Also, we don't want to give EVERY staff member access to Smarthseet just to fill out a cell every week or so.

Can I have a form fill out a row in an intermediate Smartheet and then use references to place that information into given cells in another Smartsheet?

Thank you!

Mike

Andrée Starå

Hi @John Michael (Mike) Munsil

I hope you're well and safe!

Have you explored using the Update Request feature instead?

Would that work/help?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

John Michael (Mike) Munsil

Well, the update request can't be automated for a range of columns within a given row, at least not that I know of. The idea is to automate everything if possible.