Formula combinations for cross sheet references<\/a><\/p>Let me know if that makes sense and works for you!<\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-11 18:46:57","updateUser":{"userID":152232,"name":"jhickok","url":"https:\/\/community.smartsheet.com\/profile\/jhickok","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T18:46:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":[]},{"discussionID":96408,"type":"question","name":"Automated Workflow - Copy Rows","excerpt":"Hi! I'm hoping this is an easy answer! I have a worksheet (grid) where I want every single row\/column copied to another sheet (grid) every Monday. I set up an automated workflow with no conditions, and it's not working. I ran it to test this morning to no avail. Do I need to set conditions? Is that the issue? Thank you! -T","categoryID":321,"dateInserted":"2022-10-10T18:20:05+00:00","dateUpdated":null,"dateLastComment":"2022-10-10T18:28:55+00:00","insertUserID":134933,"insertUser":{"userID":134933,"name":"Taylar Rodgers","url":"https:\/\/community.smartsheet.com\/profile\/Taylar%20Rodgers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nNfc_347Db4!hMHTIRzoLX4!9v0U4w3sDeJ","dateLastActive":"2022-10-11T12:57:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":67611,"lastUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-11T19:43:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":null,"hot":3330853140,"url":"https:\/\/community.smartsheet.com\/discussion\/96408\/automated-workflow-copy-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96408\/automated-workflow-copy-rows","format":"Rich","lastPost":{"discussionID":96408,"commentID":346656,"name":"Re: Automated Workflow - Copy Rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346656#Comment_346656","dateInserted":"2022-10-10T18:28:55+00:00","insertUserID":67611,"insertUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-11T19:43:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/U5UMXAO5XWWF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-11T12:57:19+00:00","dateAnswered":"2022-10-10T18:28:55+00:00","acceptedAnswers":[{"commentID":346656,"body":"
Click on the \"Run once\" and change it to custom then weekly.<\/p>
Also you may need a condition if I'm not mistaken. Maybe something easy like if a column is not blank type of thing. Pick a column that will never be blank.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-11 12:57:19","updateUser":{"userID":134933,"name":"Taylar Rodgers","url":"https:\/\/community.smartsheet.com\/profile\/Taylar%20Rodgers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nNfc_347Db4!hMHTIRzoLX4!9v0U4w3sDeJ","dateLastActive":"2022-10-11T12:57:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":96245,"type":"question","name":"How do you create new Programs within Control Centre?","excerpt":"Hopefully a really simple question... I have the PMO Program in Control Centre and that's working well with blueprints etc, however I want to setup another program for Finance and I can't see how or where to do this?","categoryID":343,"dateInserted":"2022-10-05T11:05:48+00:00","dateUpdated":"2022-10-06T12:08:23+00:00","dateLastComment":"2022-10-11T12:35:17+00:00","insertUserID":136915,"insertUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":136915,"lastUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":52,"score":null,"hot":3330461465,"url":"https:\/\/community.smartsheet.com\/discussion\/96245\/how-do-you-create-new-programs-within-control-centre","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96245\/how-do-you-create-new-programs-within-control-centre","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":96245,"commentID":346737,"name":"Re: How do you create new Programs within Control Centre?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346737#Comment_346737","dateInserted":"2022-10-11T12:35:17+00:00","insertUserID":136915,"insertUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-11T12:35:21+00:00","dateAnswered":"2022-10-11T12:35:17+00:00","acceptedAnswers":[{"commentID":346737,"body":"
Hi All, I needed to ask the Customer Success \/ Support team to set this up for me as it looks like I couldn't do this on my own.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-11 12:35:21","updateUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":466,"urlcode":"control-center","name":"Control Center"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">