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
@D.wilson<\/a> <\/p> Are you putting a space between the < and the =? You can't do that.<\/p>"},{"commentID":360528,"body":" @D.wilson<\/a> <\/p> It looks like this is the part with the space that's messing it up: [TOTAL Risk score]@row < =70)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-03 22:04:51","updateUser":{"userID":157834,"name":"D.wilson","url":"https:\/\/community.smartsheet.com\/profile\/D.wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-03T22:04:09+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":[]},{"discussionID":100626,"type":"question","name":"Setting Task Due Dates Based on Project Due Date (Retroactively)","excerpt":"I need to create a sheet\/template where the due dates of tasks are based on the project's due date (i.e., I want to \"back into\" the project due date). I assume formulas or helper columns might be necessary to accomplish this (e.g., =Projectt_Due_Date-90, etc.), but I can't wrap my head around how to do this using…","categoryID":322,"dateInserted":"2023-02-03T01:23:44+00:00","dateUpdated":null,"dateLastComment":"2023-02-03T21:18:17+00:00","insertUserID":146191,"insertUser":{"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":"✭✭"},"updateUserID":null,"lastUserID":146191,"lastUser":{"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":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3350847721,"url":"https:\/\/community.smartsheet.com\/discussion\/100626\/setting-task-due-dates-based-on-project-due-date-retroactively","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100626\/setting-task-due-dates-based-on-project-due-date-retroactively","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":100626,"commentID":360534,"name":"Re: Setting Task Due Dates Based on Project Due Date (Retroactively)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/360534#Comment_360534","dateInserted":"2023-02-03T21:18:17+00:00","insertUserID":146191,"insertUser":{"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":"✭✭"}},"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-03T21:18:25+00:00","dateAnswered":"2023-02-03T14:46:19+00:00","acceptedAnswers":[{"commentID":360408,"body":" Hi Tony! I remember having a similar issue and when I searched around and I couldn't use dependencies for this (I forget why, sorry), but I found a different way: <\/p> Have the helper row (the light grey in the picture below, my row #35) label the start and end date of the entire project. <\/p> Each task will have this formula for the start date and end date: =IF(ISDATE([End Date]35), [End Date]35 - 61<\/strong>, \"TBD\")<\/p> You change the bold number to the number of days prior to the project end date that you want each task done by. Does that work for you? <\/p>![\"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":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/PAIYC5J1WGGU\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
