Simple lock row automation doesn't work 100% of time

Justin Ramos

I have an automation to lock a row once a check box is manually checked off in a report. However, it only works about 80% of the time. I have another automation to unlock the row when unchecked as well however, about 20% of the rows that are checked are never locked. I'm thinking a workaround could be a move row when check box is checked to an archive then lock the row? Any ideas?

Jeff Reisman

I would investigate the 20% of rows that get checked but never locked. Pull the activity log to see who modified them and when, and if there were any other changes to the row or other automations that might have prevented or reversed the lock.

Justin Ramos

@Jeff Reisman When I compare the cell history with when it was checked against the activity log, there seems to be nothing preventing it from working. It just sometimes doesn't work. Maybe because there are too many edits at once? Either way, when looking at the activity log for those 20% that it doesn't work for, it just says that it was checked with no automation following it.

Mindfull

https://community.smartsheet.com/discussion/comment/317344#Comment_317344

I am also facing the same issue, but I am not sure if too many edits impact the locking, because in my sheet i have put the below condition, still it is not working. Any help on this will be appreciated.

BR