Problem with automation and Auto-Number column ''Modified date''
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.
Answers
-
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
bassam.khalil2009@gmail.com
☑️ 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"
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!