由符号列触发的警报自动化，该列使用标记不能找到所有行
有一个列公式(在columnX上)，它在满足某些条件时将标志设置为红色。公式是正确设置标志。
已经创建了自动化，它根据columnX的Flag值向行上的联系人发送警报。自动化每天凌晨2点运行。发送的警报没有包含所有应该包含的行。例如，昨天的警报包含3行，但是当早上7点打开表单时，有5行被标记。作为测试，自动化在此时运行一次，警报包含所有五行。
是否需要打开工作表以使列公式更新标志值?如果是这样，有没有建议的工作。
谢谢你，约翰
答案
-
Sameer Karkhanis ✭✭✭✭✭✭
您的警报是基于日期/时间触发的，因此它将只包括那些在通知发出之前随时更新的行。在工作流运行之后发生的任何更新都将包含在第二天的运行中。
-
约翰Knipper ✭✭✭✭谢谢你的回复，Sameer。
通过检查单元格版本历史记录，我已经确认在两次自动警报之间没有更改报告中丢失的行。那不是原因。
部分列公式比较[promise Date] < Today()。当自动化运行时，此值将更新(即没有人需要打开工作表以导致更新)，我是否正确?
-
保罗新来的 ✭✭✭✭✭✭任何带有TODAY函数的东西都需要被触发以保持最新状态。要触发TODAY函数，需要激活工作表。激活工作表可以通过打开它、更新请求、表单条目和更改单元格值的自动化(记录日期/更改单元格/复制行收件人/移动行收件人等)来完成。
我的建议是插入一个名为“TODAY”的日期类型列。然后，您可以设置一个记录日期自动化，在每天凌晨1点运行，并在此列中记录日期。你可以设置任何你想要的条件，只要这个条件每天都会触发，比如主列是空的或者主列不是空的。
这将在每天凌晨1点更改列中的日期，这将激活工作表并更新TODAY函数，以便在凌晨2点自动运行时实际标记所有行。
thinkspi.com
类别
Excellent!<\/p>
Happy to help!<\/p>
<\/p>
✅Please support the Community by marking the post(s)<\/em> <\/em><\/strong>that<\/em> <\/em><\/strong>helped or answered your question or solved your problem with <\/em>the accepted answer\/helpful, Insightful\/Vote Up\/Awesome<\/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":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":103327,"type":"question","name":"UNPARSEABLE IF AND MAX FORMULA HELP","excerpt":"Hi Community, Can you tell me what is wrong with this formula? If the automatically populated created date is Max it returns 1 if not 0. =IF(Created@row ={MAX}Created:Created),1,0)","categoryID":321,"dateInserted":"2023-03-29T14:25:38+00:00","dateUpdated":null,"dateLastComment":"2023-03-29T15:11:38+00:00","insertUserID":159909,"insertUser":{"userID":159909,"name":"Bet1996","url":"https:\/\/community.smartsheet.com\/profile\/Bet1996","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZOEixqpd9v6S2yLqLSdfuCQdy_qRIHxbusCtP4=s96-c","dateLastActive":"2023-03-29T17:42:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127476,"lastUser":{"userID":127476,"name":"Leibel S","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-29T15:09:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3360203236,"url":"https:\/\/community.smartsheet.com\/discussion\/103327\/unparseable-if-and-max-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103327\/unparseable-if-and-max-formula-help","format":"Rich","tagIDs":[219,254],"lastPost":{"discussionID":103327,"commentID":369489,"name":"Re: UNPARSEABLE IF AND MAX FORMULA HELP","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/369489#Comment_369489","dateInserted":"2023-03-29T15:11:38+00:00","insertUserID":127476,"insertUser":{"userID":127476,"name":"Leibel S","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-29T15:09:00+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-03-29T17:42:16+00:00","dateAnswered":"2023-03-29T15:11:38+00:00","acceptedAnswers":[{"commentID":369489,"body":"
