Will locking a parent row lock the children?
Hello,
I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month, and then it automatically locks the entire month. This would mean that it would need to lock the parent and children rows.
I have it set up to lock the parent row when "Supervisor Signature" is "Approved," but does this mean that the children rows are locked as well?
I would like to have one document (per employee) for all 12 months of tracking leave (we only report time taken off), for the employee to revisit each month. I would want to have a setting so I know they don't alter their time after the supervisor has approved it.
Thank you!
Deena
Deena Duran, MA (She/Her)
🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟
🎓️ Core App, Project Management, and System Administrator Certified 🏅
Senior Business Analyst
University of New Mexico Health Sciences
Best Answer
-
Hi Deena,
It will not lock the children rows automatically.
As a possible workaround, you could add a formula and workflow that would lock the children as well.
Would that work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
Answers
-
Hi Deena,
It will not lock the children rows automatically.
As a possible workaround, you could add a formula and workflow that would lock the children as well.
Would that work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
Thank you Andrée, I was able to use a formula to automatically fill the children row, which allowed the workflow previously set up to lock those rows as well. It should work well! Thank you!
Deena Duran, MA (She/Her)
🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟
🎓️ Core App, Project Management, and System Administrator Certified 🏅
Senior Business Analyst
University of New Mexico Health Sciences
-
Excellent!
Happy to help!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 416 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!