I have a move automation triggered from a cell update. There are currently about 900 records that I would like to move to a separate worksheet. The worksheet contains about 170 columns that would be moved. There are multiple people in the worksheet throughout the day. Additionally, there are other automations launching based on other criteria.
It seems that if I select a large of records, i.e. 100 and click save the automation is not activating. The records do not seem to move even after a period of time. Could it be that automations are bumping into each other as other users are working in the worksheet? Even though, the records I am working on would not be updated by anyone else.
It does seem that if I select a smaller set, i.e. 10 and turn the trigger on and off, eventually the automation will move the records.