Need Help: Lock row automation is locking incorrect rows
Here is workflow:
1) Each staff has their own timesheet which they will receive update request everyday to update their works.
2) Automation is set to lock the rows after 7 days from the actual date (Meaning 1st July row will be locked on 8th July)
With reference to the following screenshot, today is 18th July. But rows 14th - 20th July has been locked. It happened to at least 50 - 60 sheets. We are still checking if there are more.
Has anyone experienced such incident before?
One easy way I know is to manually unlock the rows, sheet by sheet. But will the issue occur again?
We have submitted the case to Smartsheet Support but receiving the reply that they may taking longer to response. As this is urgent and impacting the work records of many staff, so I am checking here if anyone has any suggestion or know how we can resolve this issue.