forms and cell linking to a secondary sheet
Hello
I have created a Time sheet form that i sent out to 11 employees to gather all the daily info.
This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time.
Ive been trying to figure out how to link the cells to another sheet so the secondary sheet is auto populated by the Time sheet smartsheet.
The problem is you cant link to a cell in an empty row, and the from only populates to the next available empty row.
any ideas??
I really like the form as a timesheet because i only have to update drop down menus on one sheet and its much easier to make things fool proof on it.
thanks
Comments
-
Hi,
You would need to use a cross-sheet formula structure for it to work. Do you only want to show the same thing on the other sheet?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives