Best Practice: Automatically Lock Rows After Status Changes?

jhonnmick

Hi everyone 👋

I’m working on a workflow where once a task is marked “Completed”, I’d like to automatically lock that row to prevent any accidental edits.

I know you can manually lock rows or use automation to change values, but is there a native way to auto-lock a row after a specific status update? Or is the only option still through an Admin running a script via Bridge or API?

Curious to hear how others are handling this, especially in shared project sheets with multiple editors.

Thanks!

Jhonn Mick

Naeem Ejaz

Use conditional formatting to “grey out” or “strike-through” completed tasks.

Smartsheet Bridge allows you to build a workflow like:

• Trigger: When a row's status changes to “Completed”
• Action: Lock the row via Bridge’s Smartsheet modules

Andrée Starå

https://community.smartsheet.com/discussion/141239/best-practice-automatically-lock-rows-after-status-changes

Hi,

I hope you're well and safe!

You can add a Workflow that triggers from a change to the Status, and when it's completed, it locks the row. (see below)

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏