Can Bridge do this?
My company recently upgraded to Advance (yay!), and I'm evaluating the best way to rework an existing solution using Bridge. Can Bridge create cell links within the same sheet? In an ideal world, here's what my sheet would do:
- Managers submit form entries with an assignment for up to 6 team members.
- If more than one team member is assigned, Bridge will create copies of the form entry row in the quantity needed to accommodate all team members. For instance, for the entry in Row 2, I need 4 copies created so I have a row for all 5 team members. (I need a row for each team member so I can display the sheet using Calendar App and group assignments by team member.)
- When creating copies of the row, Bridge will link data from the Form Entry Row to the copies. Managers can submit updates on Form Entry Rows in Dynamic View. In the example of Row 2 below, if the manager changes the Tech 2 name from Tyler Jones to Alex Dicus, I need the "Team Member Name to Group by" cell in Row 3 to update to Alex Dicus. The same is true for other fields as well. If they change the Start Date in the Form Entry Row, that needs to change in all copies of the Row.
- Bonus: I would also love to dynamically add or delete rows if the number of techs changes. For instance, if I removed Rex Thomas from the Row 8 entry and left that column blank, Row 9 would be deleted altogether. If I went back into Dynamic View and added Rex back as Tech 2, a copy of the row with the associated links would be re-added. If this isn't possible, I will just have Bridge create 5 copies of each Form Entry Row.
Alternative: If Bridge doesn't allow cell links within the same sheet, I can create a separate source sheet for managing assignments.
I'd love to hear ideas from others familiar with Bridge!
Answers
-
@Julie Fortney you can't create cell links within the same sheet, but you can do custom formulas like "=[Tech 2]4 to reference a specific cell. You can add or delete rows in bridge, and you can create "triggers" to run the workflow when sheet data is changed. You will need conditional junctions to make sure the workflow only runs a certain path when it meets the right criteria.
This would be a complicated workflow lol, but not impossible.
-
Thanks @Samuel Mueller! I might as well just jump in the deep end!
-
@Julie Fortney I'm happy to help, send screenshots! haha
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives