Automation: "Lock rows" command doesn't work

Rudy Moons

Hi,

I have an issue with automation on one specific grid.

A simple automation to lock a row when the status (status is a link from the project schedule) is set to "Closed"

I added a message to it to see if the automation is triggered and I get the message but the row stays unlocked :(

Any thoughts?

(This kind of automation does work on my other sheets, but on this specific sheet it doesn't work)

Andrée Starå

Hi @Rudy Moons

Unfortunately, it's by design, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas. This includes Request an approval, Move rows, Copy rows, Lock rows, and Unlock rows. For example, if the Status cell on the row is populated by a cell link with a value from another sheet, changes to that cell value through the cell link will not trigger a workflow that locks the row when Status changes to Complete.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rudy Moons

Hi @Andrée Starå ,

Thank you for the info, i Assumed it could be something like that, now i'm sure ;)

Best regards

Rudy

Andrée Starå

Hi @Rudy Moons

Unfortunately, it's by design, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas. This includes Request an approval, Move rows, Copy rows, Lock rows, and Unlock rows. For example, if the Status cell on the row is populated by a cell link with a value from another sheet, changes to that cell value through the cell link will not trigger a workflow that locks the row when Status changes to Complete.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rudy Moons

Hi @Andrée Starå ,

Thank you for the info, i Assumed it could be something like that, now i'm sure ;)

Best regards

Rudy

Andrée Starå

@Rudy Moons

You're more than welcome!