I am not able create a line item in multiple sheets with single input form. Am I missing something or this kind of feature does not really exists in Smartsheet. Experts, please advise.
My method would probably work If you don't need to be able to edit the columns from the first sheet.
What do you think?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Technically not possible, a form is associated with a single sheet. However, you could set up copy row automations on the Sheet associated with the form to reproduce the form entry on any other Sheet(s) you'd like.
I made a video showing how to achieve this, you can view it at https://youtu.be/Ah1XrCAkhUc.
This is how a simple automated workflow can be built to copy form entries to multiple Sheets.
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Yeah, I tried 'Copy Rows' in automation. But I need only certain columns to be replicated in Sheet2, 3, ... Copy Rows replicates all columns from Sheet1 into Sheet2,3..
Hi @Narasimhamurthy Prahaladarao
To add to Dan’s excellent advice.
Another option could be to use cross-sheet formulas (VLOOKUP or INDEX/MATCH) to collect the values from Sheet 1 to the other sheets.
Would that work/help?
I hope that helps!
Be safe and have a fantastic day!
✅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!
Hi @Andrée Starå
Yeah, VLOOKUP or index/match will work ,but I need to key in primary column data manually to every sheet.
The simplest method would be to add an auto-number column in the main sheet and then add a so-called helper column in the other sheets where you add the numbers manually.
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.