Problem with automation and Auto-Number column ''Modified date''

Julie Barbeau

Hi,

I have a problem with automation vs Auto-Number column date. I created an automation to lock a row when column ''Commande ou soumission envoyée'' is checked. Problem is, when a add a check in one row, all the ''Modified date'' for all the row are updated. See below my automation and the result in yellow.

Bassam Khalil

Hi @Julie Barbeau 

Hope you are fine, if ''Modified date'' is a system column then when you change any cell in that row the date in the ''Modified date'' will record the date of change.

you can solve this problem in deferent approach if you like i can help you in configuring your sheet and workflow please call me :

My Email : Bassam.k@mobilproject.it

Julie Barbeau

HI@Bassam Khalil

I got it but if the automation asked to lock a row when there is specific modification on this row (check box), why all the row who are not modified and already lock are updating modified date?