Same row versus different row in Reports
Hello,
Scenario:
I have two sheets, sheet A and sheet B.
On sheet A there is a column titled Survey Number, this is where the user enters the survey number. If I was to input data on Sheet B, can that information be linked to the primary column instead of creating a new row in the report? See how there's a new row (line #9) can that row be inserted above under survey number 987?
Answers
-
Hi @David Granados
Hope you are fine, as i understood that you want each new children row to be added under its parent when the user submits, Unfortunately, this feature is not currently available. You can submit a Smartsheet Product Enhancement Requests using this form.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I hope you're well and safe!
Yes, but you'd have to collect the information together in one row in the same sheet (or another sheet) for it to work by using cross-sheet formulas combined with VLOOKUP or INDEX/MATCH.
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!
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.
-
Hi Andree,
Can you show me what I would need to do?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives