Automations

the name could differ. I would…","categoryID":321,"dateInserted":"2020-10-22T09:19:29+00:00","dateUpdated":null,"dateLastComment":"2020-10-23T07:29:11+00:00","insertUserID":127883,"insertUser":{"userID":127883,"name":"Gary Mcgrane","url":"https:\/\/community.smartsheet.com\/profile\/Gary%20Mcgrane","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gg2aTJ2c0uRp7abLaQBn-wwXSyY6T7ucEaq28mi6g=s96-c","dateLastActive":"2020-11-18T09:46:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":63,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72466\/form-notification-email-address","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72466\/form-notification-email-address","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":72445,"type":"question","name":"SmartSheet Alert Mail Sender","excerpt":"Hi all, I am the owner of 10 sheets each of one is used by different users. I have set up alerts automation but when the email is sent, it is always shown my email address instead of that of the user. This is a problem as the email is sent to external customers who are always receiving email from me and not from the…","categoryID":321,"dateInserted":"2020-10-21T16:16:09+00:00","dateUpdated":null,"dateLastComment":"2020-10-21T16:39:21+00:00","insertUserID":127845,"insertUser":{"userID":127845,"name":"Massimo Damiano","url":"https:\/\/community.smartsheet.com\/profile\/Massimo%20Damiano","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-30T16:32:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":108511,"lastUser":{"userID":108511,"name":"Mary_A","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mary_A","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcAbK3ckPIQGOYRIi1Pf_Zsn_l7skQOu-90HC3r=s96-c","dateLastActive":"2023-07-11T13:11:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":52,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72445\/smartsheet-alert-mail-sender","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72445\/smartsheet-alert-mail-sender","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":72381,"type":"question","name":"Novice - Date Status Changed","excerpt":"I want to track when a project changes Status. I'm primarily using the Card View and want the date the Status changes or the project switches swim lanes, to have that day's date. For example: Old Status: Reviewed Date: 10\/19\/2020 New Status: Completed New Date: [Date Status was changed]","categoryID":322,"dateInserted":"2020-10-20T01:55:31+00:00","dateUpdated":null,"dateLastComment":"2020-10-21T06:19:13+00:00","insertUserID":127752,"insertUser":{"userID":127752,"name":"Alexandra Jackson","url":"https:\/\/community.smartsheet.com\/profile\/Alexandra%20Jackson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-02T06:57:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72381\/novice-date-status-changed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72381\/novice-date-status-changed","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":66407,"type":"question","name":"how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?","excerpt":"Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a way to make this dynamic? using the ' =ExampleCell1 ' syntax is for the current sheet. How would I…","categoryID":321,"dateInserted":"2020-03-01T19:08:29+00:00","dateUpdated":"2020-03-01T19:09:38+00:00","dateLastComment":"2020-10-20T17:59:27+00:00","insertUserID":119092,"insertUser":{"userID":119092,"name":"campbellja","title":"","url":"https:\/\/community.smartsheet.com\/profile\/campbellja","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-02T17:04:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":119092,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-14T20:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":223,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/66407\/how-do-you-reference-a-single-cell-in-an-external-sheet-dynamically-formulas-cell-linking","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66407\/how-do-you-reference-a-single-cell-in-an-external-sheet-dynamically-formulas-cell-linking","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":72215,"type":"question","name":"Random Updates - Cell History","excerpt":"Hi, we've been using a format where once a form is submitted, a row is copied to another \"master\" sheet that the team can manage off of. Recently, I've made some changes to the process (around when the copying happens), but what we're seeing is that in our Master sheet, there are random updates to cells (we have alerts set…","categoryID":322,"dateInserted":"2020-10-14T15:03:22+00:00","dateUpdated":null,"dateLastComment":"2020-10-19T11:59:56+00:00","insertUserID":116755,"insertUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2023-06-15T17:55:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72215\/random-updates-cell-history","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72215\/random-updates-cell-history","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":70076,"type":"question","name":"How do I make formulas automatically carry down to the next line when a new form is submitted?","excerpt":"I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form. I want those vlookups to be added automatically to each line as new forms are submitted. How do I do this?","categoryID":321,"dateInserted":"2020-07-23T16:41:23+00:00","dateUpdated":"2020-07-23T16:42:04+00:00","dateLastComment":"2020-10-17T14:51:27+00:00","insertUserID":124494,"insertUser":{"userID":124494,"name":"TJones Hoshizaki","url":"https:\/\/community.smartsheet.com\/profile\/TJones%20Hoshizaki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2nnXfx9K0j4!0lFQP6RVeXo!ndse8xN06XN","dateLastActive":"2022-10-18T16:41:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":124494,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":772,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/70076\/how-do-i-make-formulas-automatically-carry-down-to-the-next-line-when-a-new-form-is-submitted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70076\/how-do-i-make-formulas-automatically-carry-down-to-the-next-line-when-a-new-form-is-submitted","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":72283,"type":"question","name":"Automate checking a box if date column is less than 2 weeks?","excerpt":"I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!","categoryID":322,"dateInserted":"2020-10-15T18:51:20+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T19:21:54+00:00","insertUserID":111081,"insertUser":{"userID":111081,"name":"brianne111081","url":"https:\/\/community.smartsheet.com\/profile\/brianne111081","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2T9cPlGCs_w!W2dcn1BmWjw!-qOv6zZN1n6","dateLastActive":"2022-10-27T16:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":119014,"lastUser":{"userID":119014,"name":"Kelly Drake","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Drake","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2S3BS3UA017T\/n78P8XVGIT7NW.jpeg","dateLastActive":"2023-07-14T16:56:27+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":297,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72283\/automate-checking-a-box-if-date-column-is-less-than-2-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72283\/automate-checking-a-box-if-date-column-is-less-than-2-weeks","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T20:40:44+00:00","dateAnswered":"2020-10-15T19:21:54+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":72239,"type":"question","name":"Using Workflows to Populate Cell Values","excerpt":"Hi, I'm trying to use workflows to auto-populate a Date Column. Example: When \"Work Order State\" changes to \"Scheduled\" populate a system time-stamp in \"Scheduled Date\". Is this possible? Thanks, Quinn","categoryID":322,"dateInserted":"2020-10-14T21:03:41+00:00","dateUpdated":null,"dateLastComment":"2020-10-14T21:30:57+00:00","insertUserID":127591,"insertUser":{"userID":127591,"name":"Quinn Ehle","url":"https:\/\/community.smartsheet.com\/profile\/Quinn%20Ehle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-14T21:54:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":122,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72239\/using-workflows-to-populate-cell-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72239\/using-workflows-to-populate-cell-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">