Multi-tracking users in a locked column based on a cell change unlocked column for all records
I think this requires some function list designing, for the automation feature does not allow this based how our complex sheets are setup. In our tracking Smartsheet, we're trying to systematize the multi tracking of our users (Techs) into a locked column.
User 1 (Tech 1) is assigned a record (ticket #) in "Assigned To" unlocked column , but User 2 (Tech 2) logs in and goes to "Status" (unlocked column) and updates it's record from a pull down menu to "Finalized." We want to track the user (Tech#) who finalized that record in it's own column "Finalized By" (locked).
In short, we're mulit-tracking Techs who are assigned a ticket and either the same or another Tech finalizes a ticket within our sheet; we'll eventually report which Tech who finalized respective ticket. Hope that makes sense, ahh lil help please and thank you in advance.
Answers
-
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:Β
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
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.
-
Hola AndreeΒ ο»Ώ@AndrΓ©e StarΓ₯ο»ΏΒ ,
Happy Friday, thanks for the kind words, hope all is well & safe, Β I actually go by Andre (almost too), and not to confuse the community hahaha. Anyhow, I believe I was able to utilize another solution within our sheet: "Activity Log" Track and View Sheet Activity | Smartsheet Learning Center however I still want to look deeper into your solution AndrΓ©e, which I did initially brainstorm a bit before posting and kinda of suspected I would probably do some cross sheet formulas and maybe a VLookup while drafting my instruction set solution. Thanks for marrying those two ideas though, feels like thatβs promising way in tracking the alternative tech who marked a ticket as finalized.
Β
Community & ο»Ώ@AndrΓ©e StarΓ₯ο»ΏΒ ,
On a different path, is that "Activity Log" table referenceable and play nicely within our sheets? Ideally, automating these entries to see if Tech X closed Tech y's ticket in our tracker sheet would be a homerun for us. For now, I can manually download that into a .csv file and pivot table/report off it. Justifying our sheet restriction reasoning, we really don't want any tech to alter that column in our tracker sheet, and finally be able to report of that. Can anybody advise if that's doable and how to? Thanks all for your shares too.
Β Good Days,
Β Clemente "Andre" Inocente
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!