修改日期(由系统自动填充)更改所有记录，而不需要对工作表进行任何修改

Vinit库马尔
Vinit库马尔 ✭
在内容基本知识

嗨,团队,

在我的智能表中，修改日期是一个自动填充/系统生成的列，即使我们没有在任何记录中做任何更改，也会自动更改所有记录。这在我们的工作流程中造成了问题。我们已经将修改日期定义为工作流的触发点。因此，所有记录的工作流被触发了很多次。当我们在浏览器中打开智能表单时，就会发生这种情况。

标签:
· 在Facebook上分享 在Twitter上分享

答案

类别

Might be you need to move the first )<\/p>

try this<\/p>

=INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report 22-23 Month}, \"April\", {OPK Monthly Report 22-23 Grantee Name}, Grantee@row), 1)<\/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":106563,"type":"question","name":"Embed Smartsheet fields into Automation emails","excerpt":"It would be great if we could embed Smartsheet fields into the body of an automation email. For example, I have several emails going to different departments and if the auto email could be set-up like below, it would save time, clicks, confusion, etc.: <> has submitted a new request. The request…","categoryID":321,"dateInserted":"2023-06-16T18:25:31+00:00","dateUpdated":"2023-06-19T08:27:13+00:00","dateLastComment":"2023-06-16T18:54:24+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T18:52:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-19T10:30:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":1,"hot":3373883695,"url":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106563,"commentID":381070,"name":"Re: Embed Smartsheet fields into Automation emails","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381070#Comment_381070","dateInserted":"2023-06-16T18:54:24+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-19T10:30:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"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-19T08:27:32+00:00","dateAnswered":"2023-06-16T18:49:50+00:00","acceptedAnswers":[{"commentID":381065,"body":"

Hi @jl.furstenberg<\/a> <\/p>

I hope you're well and safe!<\/p>

It's already possible with the Placeholder feature.<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2479256-customize-the-content-of-your-alerts-and-requests\n <\/a>\n<\/div>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106543,"type":"question","name":"Automation and Email Recipient","excerpt":"Hello, Is the email notification through the automation criteria only available to recipients with Smartsheet accounts or to anyone whose email address was entered in the recipient field? Thank you.","categoryID":321,"dateInserted":"2023-06-16T03:56:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T04:30:53+00:00","insertUserID":162449,"insertUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162449,"lastUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3373778864,"url":"https:\/\/community.smartsheet.com\/discussion\/106543\/automation-and-email-recipient","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106543\/automation-and-email-recipient","format":"Rich","lastPost":{"discussionID":106543,"commentID":380961,"name":"Re: Automation and Email Recipient","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380961#Comment_380961","dateInserted":"2023-06-16T04:30:53+00:00","insertUserID":162449,"insertUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"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-16T04:29:02+00:00","dateAnswered":"2023-06-16T04:24:16+00:00","acceptedAnswers":[{"commentID":380960,"body":"

Hi,<\/p>


<\/p>

You can send notifications to any valid email address. If you're planning to send alerts or reminders with a link to the sheet, the user will not be able to click the link and access it if they do not have a Smartsheet account and not shared to the sheet.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5383,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 索引收集错误

    你好!我试图使用INDEX COLLECT函数来获取数值。月的总数过滤器在两个工作表之间匹配名称。这是我使用的公式，它返回一个不正确的参数集错误。=INDEX(COLLECT({OPK月报22-23未填写0-3}，{OPK月报…

  • 嵌入智能表字段到自动化电子邮件

    如果我们能将Smartsheet字段嵌入到自动化电子邮件的正文中，那就太好了。例如，我有几封发给不同部门的电子邮件，如果自动电子邮件可以像下面这样设置，它将节省时间，点击，混乱等:<>已经提交了一个新的请求。请求……

  • 自动化和电子邮件收件人

    您好，通过自动化标准发送的电子邮件通知是否仅对拥有Smartsheet帐户的收件人或在收件人字段中输入电子邮件地址的任何人可用?谢谢你！