Locking row automatically or locking a sheet automatically
Can a row be automatically locked during certain time of the day to prevent input of data during a particular time period? If not can a sheet be locked during a particular time period of the day and automatically reopens for another period to allow input of data?
Any help would be grateful.
Answers
-
I hope you're well and safe!
You can use multiple workflows combined with the lock/unlock row action for specific or all rows.
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.
-
Hi Andre,
Thanks for responding. Can you say if this is a function which can be carried out on business plan of Smartsheet. If so, is it possible to direct me where this is located?
Help Article Resources
Categories
Check out the Formula Handbook template!