Update a column for multiple rows based off user input

Hello,
I am not sure if this is possible without Control Center (and I'm partially expecting folks to respond with Control Center as the answer LOL).
I am wondering if the new workflows that were added recently like the Change Value in a Cell could help do this.. but I currently use Smartsheet to assign calls to a call listening group/auditing group. Right now I have to go into the individual sheets to do the assignments. I'm wondering if it's possible to create a form where I can input the Sheet name, the person to assign the calls to, and the # of calls to assign and then have the individual sheets reference that information and update the assigned column?
I can set it up so it works on one row at a time, but is it possible to have it assign a set # of calls automatically? For instance, I assign 50 calls to Linda.. .. can I somehow make it so sheets know to just assign 50 and not apply it to either a) the whole column or b) only one row.
I hope this makes sense!!
Answers
-
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
Here's a possible workaround or workarounds
- Create a master sheet where the form is submitted and then add Workflows for each sheet and set it up, so the row(s) gets copied/moved over to those sheets.
Make sense?
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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives