Add form response to a cell rather than to a row
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
Making mistakes is the fastest path to excellence.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Making mistakes is the fastest path to excellence.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives