Linking rows
Hi guys,
I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel.
I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen throughout the event day. I create specific columns for the different departments and set "x"s in each line that concerns the particular department. When applying filters I receive specific schedules.
Now, to simplify this process, I was wondering if it is possible in smartsheet to have one masterfile and create a link with another sheet so that every row that has an "x" in a specific column is copied to the other sheet?
Comments
-
Hi,
It sounds to me that it would be easier for your use case to use reports instead.
One report per department maybe? Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
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.
-
You are right. That works perfectly, thanks!
Is there also a way that complete rows from other sheets (with timings) are fed into the master sheet?
-
Happy to help!
Yes, manually or automatically with a service like Zapier or similar.
Best,
Andrée
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives