Workflow becomes invalid after each trigger.
Hi,
I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in form, approval request should get triggered. Since we are not sure, what column user is going to change, we kept the triggering point to modified date. But workflow is getting invalid after each trigger. I have too enable it each time or edit and save.
请求你的帮助。
Answers
-
Paul Newcome ✭✭✭✭✭✭Are you able to provide a screenshot of how the automation is set up?
thinkspi.com
-
If I am using any column other then modified date, it doesn't get invalid. But my requirement is workflow should be triggered irrespective of which column user edits. So i can not give any particular column name. Giving all the column names in trigger does not sound good. Since modified date column is updated each time users edits something, i have set it as a trigger point.
-
Paul Newcome ✭✭✭✭✭✭
What about the rest of your automation? I don't think that the trigger is what is causing it to fail.
thinkspi.com
-
If am giving any other than modified date, it is working fine each time. For modified date column, workflow is triggered for the first time and then becomes invalid.
-
Paul Newcome ✭✭✭✭✭✭
It is odd that would cause an issue. I have used that column as a trigger in the past with no issues.
Try this...
Create a text/number column, then enter the following formula into it:
=[Modified Date]@row + ""
Then set your trigger for whenever this new column changes and see if that makes a difference.
thinkspi.com
-
Hi Paul,
Thanks a lot. It worked..!!!
-
Paul Newcome ✭✭✭✭✭✭
Help Article Resources
Categories
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/4CHG4ANM0HYJ\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-03 21:18:25","updateUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-02-03T21:18:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":100621,"type":"question","name":"COUNTIFS with HAS two words\/phrases in same cell","excerpt":"Hi! I am trying to write a formula to count ONLY when the cell in the description column has BOTH \"eat\" AND \"scale\". I want to use HAS because sometimes I want to search for an acronym and I think it is counting other combinations of letters when I use CONTAINS. If the description @ cell has both phrases, I want a 1 to…","categoryID":322,"dateInserted":"2023-02-03T00:07:59+00:00","dateUpdated":null,"dateLastComment":"2023-02-03T18:55:07+00:00","insertUserID":157726,"insertUser":{"userID":157726,"name":"mel_","url":"https:\/\/community.smartsheet.com\/profile\/mel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T22:00:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157726,"lastUser":{"userID":157726,"name":"mel_","url":"https:\/\/community.smartsheet.com\/profile\/mel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T22:00:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":39,"score":null,"hot":3350835786,"url":"https:\/\/community.smartsheet.com\/discussion\/100621\/countifs-with-has-two-words-phrases-in-same-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100621\/countifs-with-has-two-words-phrases-in-same-cell","format":"Rich","lastPost":{"discussionID":100621,"commentID":360503,"name":"Re: COUNTIFS with HAS two words\/phrases in same cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/360503#Comment_360503","dateInserted":"2023-02-03T18:55:07+00:00","insertUserID":157726,"insertUser":{"userID":157726,"name":"mel_","url":"https:\/\/community.smartsheet.com\/profile\/mel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T22:00:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-03T18:54:24+00:00","dateAnswered":"2023-02-03T15:56:50+00:00","acceptedAnswers":[{"commentID":360429,"body":"
If you were using multi-select columns, then HAS would be the way to go. HAS<\/a> will not work to look for values within a Text\/Number field unless you're only wanting to match the entire cell contents. <\/p>
Example: =IF(HAS([Day of Week]: [Day of Week], \"Monday\"), \"yes\", “no”)<\/strong><\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/PAIYC5J1WGGU\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-03 18:54:24","updateUser":{"userID":157726,"name":"mel_","url":"https:\/\/community.smartsheet.com\/profile\/mel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T22:00:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">