Record a date automation not working?
我有一个助教sk list, and I want to use automation to supply the date the checkbox gets checked. Here is my workflow:
Am I misunderstanding this workflow? Do I need another condition in there somewhere? Absolutely nothing happens in this sheet when I check the boxes.
Thanks!
Answers
-
Andrée Starå ✭✭✭✭✭✭First, make sure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the upper right corner) and secondly check the Permission setting for the Automations. (cog in the top right corner in the Automation overview)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
@Andrée StaråI actually don't want a notification, I just want the date populated when the box is checked. Does that make sense?
I do have automation permissions turned on for the sheet.
Thanks!
-
RossL ✭✭✭✭✭✭
我注意到它将填充后保存和refresh but it might be delayed at the moment. looking at the Smartsheet status page
-
Andrée Starå ✭✭✭✭✭✭
Happy to help!
是的,这是很有意义的。
Strange!
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])
Also, it might be because there currently is an issue, so everything is delayed.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Andrée Starå ✭✭✭✭✭✭
I read through your post again, and I think you misunderstood me. The first part described below is for changes as well, so make sure that it's set to, Include my changes...
More info.
First, make sure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the upper right corner),and secondly, check the Permission setting for the Automations. (cog in the top right corner in the Automation overview)
Did that work?
✅Remember!Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Hi Kate,
Did it get resolved? I have similar situation. Set the conditions right but it hasn't been recording dates.
-
@Prince GhoshNo, I tried all of Andree's suggestions and it still isn't working. Interestingly, it works for him when I granted access to his sheet. My next step is to reach out to Smartsheet support, although I'm not 100% sure how to do that yet. If you get an answer before me please let me know here!
-
Genevieve P. Employee AdminHi@Kate Winterand@Prince Ghosh
Another thing to check is how the workflow is triggered; actions that will automatically modify the sheet (such as Record a Date) cannot be triggered by inboundcell-linksorcross-sheet formulas.
This is perhaps how@Andrée Staråwas able to trigger the workflow, if he manually checked the box (versus using a formula).
To work around this, you may want to consider usingtime-based automationorrecurrenceworkflows. (Seethis articleon workflow triggers).
否则,如果你是手动进行改变but the workflow isn't running as expected, you can contact Support by filling out the form on this page, here:https://help.smartsheet.com/contact/smartsheetapp
Cheers!
Genevieve
-
Linda Linton ✭✭✭✭
@Kate WinterI had this same issue and finally figured it out. My 'Record a Date' automation was set to record "Date Added" when a new row is added. However, my sheet was already populated with preset row IDs. In other words, when a user added a new record, it was not actually a new row since the row ID was already there, so the automation didn't recognize it as being "Added." I had to change the automation to trigger when rows are "added OR CHANGED" and specify a field in the "When" that will only be updated once (not changed with future edits). Whew! I hope this makes sense.If not, let me know and I'll try to add some screenshots. Hope it helps!
Linda
-
skarkhoff ✭✭@Kate Winter&@Genevieve P- I'm having a similar issue. I have one column (number of cases) setup with cross-sheet formulas that gives the total number of cases per client, then I have a helper checkbox column with a formula that checks the box if the number of cases column is greater than 1.
I have my workflow setup so that when the helper column changes to checked, a date is recorded in a 3rd column. I set it up this way because I knew that I couldn't base a trigger off a column with a cell link or cross reference formula, and it had been working up until about a month ago.
In reviewing this post:https://help.smartsheet.com/articles/2479236-trigger-blocks-define-when-your-workflow-is-executedit states that a trigger can't be based on my helper column either, since that's referenceing the column with the cross-sheet formula. Is that accurate?
Most of my data on this sheet is coming from other sheets and the need for triggers to work immediately is extremely important in this workflow. If a "helper" column is no longer a solution for immediate workflow triggers, what are some other workarounds? Do I need to add a helper column for my other helper column? This sheet is quite advanced already, and runs extremely slow. I'd hate to add even more columns that will slow it down.
Help!
-
Genevieve P. Employee Admin
Can you clarify why it's important for the date to be recorded immediately? Since dates don't have time associated with them, what about running this workflow asa Date-Based workflowinstead? You could have the workflow check the sheet once-a-day to see if any rows meet your criteria, then record that day's date if they do.
For example, you could set up your workflow to run once a day at the end of the day:
Then you canset two conditions:if your other column is greater than 1, and if the Date Field is empty (so this workflow hasn't run on a previous date, otherwise the date would be overwritten for each day that the first criteria is met. Unless you want this?)
Since your workflow is doing the work of checking your column for "greater than 1", this means you can delete out the helper checkbox column which could help simplify your sheet as well.
Cheers,
Genevieve
-
skarkhoff ✭✭
@Genevieve P- The sheet I'm working on has a number of formulas to guide the user in what to do next in the sales process. i.e. if A is complete, the user will get a message stating, "move on to step B and complete the following form", etc. The formulas also check to ensure that Steps A, B & C are complete before the user can move on to Step D. That's where the cross sheet formulas come into play, I'm basically checking a number of other sheets to ensure that all steps are completed.
Most of the formulas were set up with the ISDATE() function as a filter for some of the automation, which I can replace, just didn't want to have to do the work if I didn't need to, especially since I swear it had worked up until about a month ago (by using a helper column)!
In looking forward - I have a couple other questions:
- Is it just the Record Date, Edit Cell Data and Assign people functions that are not available when selecting a cell link/cross-sheet cell as a trigger? Or does that apply to trigger based notifications and approval requests as well?
- Is there anything planned in the future to include these types of cells as triggers? Or will they only be able to be a scheduled option?
- In regards to the scheduled/custom date option - will there ever be an option for hourly instead of daily/weekly/etc?
Thank you!
-
Genevieve P. Employee Admin
1 . It's any automation that makeschangesto the sheet as an automatic action as part of the workflow, so: Approval Requests (they change the status to "Submitted" automatically), Move rows, Copy rows, Lock rows, Unlock rows, Record a date, and Assign people. I haven't tested this yet, but I would assume the newCell Change automationfalls into this category as well.
Notifications & Update Requests don't automatically make a change - instead, they send out information, and in an Update Request a user might make a manual change. This means theycanbe triggered by cell-links, no problem!
2 . As far as I'm aware, there is no plan to allow these types of workflows to be triggered by cell-links or cross-sheet formulas, as it's designed this way to prevent infinite loops or circular references.
3 . This is a great question, I'm not sure if this is on the roadmap or not. For this, and for your point 2 above, please fill out theProduct feedback form (here)to contact the Product team directly and let them know about your use-case and request.
Thanks!
Genevieve
-
Illes M ✭
Hello,
I've got a similar question and still don't understand why it doesn't work:
If a cell's value of a single drop-down list type column is changed to a specific value, the date should be recorded.
I don't want to run a daily trigger as there are lot of lines, where the data was retrospectively uploaded and is partial.
-
Genevieve P. Employee Admin
Hi@Illes M
How are you triggering the workflow? What causes the ASP (PM) cell to update?
Actions that will automatically modify the sheet (such as Record a Date) cannot be triggered by inboundcell-linksorcross-sheet formulas,or cells that reference a cell-link or cross-sheet formula.
See the Note at the bottom of this Help Article:Trigger Blocks: Define When Your Workflow is Executed
Categories
<\/p>
=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>\"//www.santa-greenland.com/community/discussion/75548/\"))), \" \"))<\/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":109460,"type":"question","name":"IF \/ OR formula then Check a Box","excerpt":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1) OR([Study Status]@row = \"In Start-Up\", 1))","snippet":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1)…","categoryID":321,"dateInserted":"2023-08-25T13:30:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:21:27+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":45,"score":null,"hot":3385956126,"url":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109460,"commentID":392616,"name":"Re: IF \/ OR formula then Check a Box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392616#Comment_392616","dateInserted":"2023-08-25T16:21:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:13:03+00:00","dateAnswered":"2023-08-25T14:14:39+00:00","acceptedAnswers":[{"commentID":392575,"body":"
Give this a try:<\/p>
=IF(OR([Study Status]@row = \"Active\/Open to Accrual\", [Study Status]@row = \"In Start-Up\"), 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":109457,"type":"question","name":"Conditional Formatting (modified date not in the last 3 weeks)","excerpt":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…","snippet":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated…","categoryID":321,"dateInserted":"2023-08-25T12:33:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161267,"lastUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3385935251,"url":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":109457,"commentID":392553,"name":"Re: Conditional Formatting (modified date not in the last 3 weeks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392553#Comment_392553","dateInserted":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T12:40:09+00:00","dateAnswered":"2023-08-25T12:37:47+00:00","acceptedAnswers":[{"commentID":392551,"body":"
There is no direct way to do this. Adding a checkbox helper column with something similar to this and then formatting based on the checkbox is the simplest way. You can even hide the extra column, as there is no reason for it to be visible.<\/p>
=IF([Modified Date]@row < TODAY(-21), 1, 0)<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&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":4991,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
![https:\/\/us.v-cdn.net\/6031209\/uploads\/5ZQW3EHHXBHG\/image.png<\/a><\/p>Am I misunderstanding this workflow? Do I need another condition in there somewhere? Absolutely nothing happens in this sheet when I check the boxes.<\/p>Thanks!<\/p>","bodyRaw":"[{\"insert\":\"I have a task list, and I want to use automation to supply the date the checkbox gets checked. Here is my workflow: \\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/5ZQW3EHHXBHG\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/5ZQW3EHHXBHG\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\nAm I misunderstanding this workflow? Do I need another condition in there somewhere? Absolutely nothing happens in this sheet when I check the boxes.\\n\\nThanks!\\n\"}]","format":"rich","dateInserted":"2021-02-01T16:32:25+00:00","insertUser":{"userID":130419,"name":"Kate Winter","url":"https:\/\/community.smartsheet.com\/profile\/Kate%20Winter","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GhuKp5tkHCKDTH_y7Q60nVExNKAjocp2MH45oSm=s96-c","dateLastActive":"2021-02-23T17:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/75548\/record-a-date-automation-not-working","embedType":"quote","name":"Record a date automation not working?"}"> https://community.smartsheet.com/discussion/75548/record-a-date-automation-not-working](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/5ZQW3EHHXBHG\/image.png\"){kind=link}