为什么警报通知非工作期间运行hours?
Is there a way to change the timing of when these automations run so that people get these notifications during working hours as opposed to when we are sleeping? Is this something a sys admin can change?
Thanks
Best Answer
-
Eric Law ✭✭✭✭✭@scot tupperYou can schedule the trigger to be timed based instead of row based.
Answers
-
Eric Law ✭✭✭✭✭
@scot tupperYou can schedule the trigger to be timed based instead of row based.
-
scot tupper ✭✭
The ones in question are row based which is how we need to manage them but thanks for your input.
Categories
=\"Milestone 1 - \" + INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) <\/p>
Or...<\/p>
=INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) + \" - Milestone 1\"<\/p>
You can see an explanation of a similar use case in this video https:\/\/youtu.be\/g9eap8EjFTI?t=272<\/a><\/p> Dan Palenchar | <\/strong>School of Sheets Solutions Consulting<\/a> (Smartsheet Aligned Gold Partner)<\/p> Smartsheet Consulting Inquiries: schoolofsheets.com\/workwithus<\/a><\/p> Smartsheet Tutorial Videos: schoolofsheets.com\/youtube<\/a><\/p>![\"Email](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/YLZSWDRJUALA\/email-signature-logo.png\"){kind=logo}
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110500,"type":"question","name":"Several Columns Have the Same Name","excerpt":"I have several workspaces that people use to make different sheets. The problem is that whenever I try to make a report for someone and I'm sorting out which columns to include, there are several columns with the same name. For instance, if the column name was 'Contacts', there are four columns named 'Contacts' which each…","snippet":"I have several workspaces that people use to make different sheets. The problem is that whenever I try to make a report for someone and I'm sorting out which columns to include,…","categoryID":321,"dateInserted":"2023-09-20T13:47:58+00:00","dateUpdated":null,"dateLastComment":"2023-09-20T15:34:19+00:00","insertUserID":166963,"insertUser":{"userID":166963,"name":"happinessisland","title":"Administrative Assistant","url":"https:\/\/community.smartsheet.com\/profile\/happinessisland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T17:58:27+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":166963,"lastUser":{"userID":166963,"name":"happinessisland","title":"Administrative Assistant","url":"https:\/\/community.smartsheet.com\/profile\/happinessisland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T17:58:27+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3390442937,"url":"https:\/\/community.smartsheet.com\/discussion\/110500\/several-columns-have-the-same-name","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110500\/several-columns-have-the-same-name","format":"Rich","tagIDs":[527],"lastPost":{"discussionID":110500,"commentID":396207,"name":"Re: Several Columns Have the Same Name","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396207#Comment_396207","dateInserted":"2023-09-20T15:34:19+00:00","insertUserID":166963,"insertUser":{"userID":166963,"name":"happinessisland","title":"Administrative Assistant","url":"https:\/\/community.smartsheet.com\/profile\/happinessisland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T17:58:27+00:00","banned":0,"punished":0,"private":true,"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-09-20T15:33:59+00:00","dateAnswered":"2023-09-20T14:26:37+00:00","acceptedAnswers":[{"commentID":396182,"body":"
