Simple lock row automation doesn't work 100% of time
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?
Answers
-
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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@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.
-
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
