Can I change a row and trigger other rows to be assigned to a person?
Hello,
I'm fairly new to smartsheets, and for my work, we are building a new template to use for project management. One of our first rows is to assign a specialist to the project once one has been determined. I want to know if there is a way to select one row in specific, and once the row (any value in the row works, but most of them are too generic) has been changed, all other rows that should be assigned to the specialist will automatically be assigned.
I haven't been able to figure out a solution for this automation and wanted to ask the community for any possible solutions.
Thanks,
Mason Kimball
Answers
-
I believe the best way to handle this would be to use a formula in the Assigned To column so that it is equal to the Assigned To column in the row above it.
You can carry this equation down the entire sheet and thus would need to only Assign the specialist in one row.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives