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



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
    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 :

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • 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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!