修改日期(由系统自动填充)更改所有记录,而不需要对工作表进行任何修改
嗨,团队,
在我的智能表中,修改日期是一个自动填充/系统生成的列,即使我们没有在任何记录中做任何更改,也会自动更改所有记录。这在我们的工作流程中造成了问题。我们已经将修改日期定义为工作流的触发点。因此,所有记录的工作流被触发了很多次。当我们在浏览器中打开智能表单时,就会发生这种情况。
答案
-
保罗新来的 ✭✭✭✭✭✭
-
Vinit库马尔 ✭
不,我们没有在任何公式中使用Today()函数。
-
Vinit库马尔 ✭
也请找到截图。所有记录同时更改的修改日期。此外,当我逐个浏览每个列并查看它们的细胞历史时,我没有发现任何列在此日期更改。
-
保罗新来的 ✭✭✭✭✭✭
-
Vinit库马尔 ✭
嗨,保罗,
我们没有使用任何公式,除了一个基于修改日期的公式(=[修改日期]@row +“”),这是您作为工作流自动化问题的一部分给出的,…是的,我在下面的活动日志中看到了。请看下面的截图。
-
保罗新来的 ✭✭✭✭✭✭
-
Vinit库马尔 ✭
-
保罗新来的 ✭✭✭✭✭✭
-
Vinit库马尔 ✭
不,那是唯一的自动化。
-
保罗新来的 ✭✭✭✭✭✭
-
Box2105 ✭✭✭✭
我最近遇到了所有行都要更新修改日期的问题。我的智能表单很简单,但确实有一个列公式,我可以在其中跟踪每一行创建后的天数。ref: =NEWTORKDAYS([日期创建]@row, TODAY (0))
我把这个计算移到了一个单独的智能表上,解决了这个问题。
类别
Happy to help. 👍️<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106616,"type":"question","name":"Groups - how many users in a group?","excerpt":"The help files indicates you can bulk upload 1,000 emails to a group. Is that the maximum number of users that can be in a group? I could not find documentation indicating how many users could be in a group. TIA","categoryID":321,"dateInserted":"2023-06-19T21:51:09+00:00","dateUpdated":"2023-06-20T08:19:00+00:00","dateLastComment":"2023-06-20T09:36:32+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T23:25:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3374465861,"url":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106616,"commentID":381246,"name":"Re: Groups - how many users in a group?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381246#Comment_381246","dateInserted":"2023-06-20T09:36:32+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T11:01:39+00:00","dateAnswered":"2023-06-20T09:36:32+00:00","acceptedAnswers":[{"commentID":381246,"body":"