When humans are connected, aligned, and supported,
they can focus and reach their full potential
Areas to explore
Announcements<\/h2> <\/div>\n \n- \nNEW! Multi-widget editing in dashboards<\/a>\n
Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of the widgets you select look uniform. You can access multi-widget editing by selecting more than one widget and clicking on the pencil icon to…<\/p>\n<\/li>\n
- \nBe aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center<\/a>\n
Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume. To improve the experience and enable…<\/p>\n<\/li>\n
- \nExpanded Data Egress coverage for Smartsheet mobile app and public APIs now generally available!<\/a>\n
Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable through the Smartsheet web and desktop applications, and not via the Smartsheet mobile app or public APIs. We’re excited to share that Smartsheet now…<\/p>\n<\/li>\n
- \nOctober Question of the Month 💭 Join the conversation and receive a badge<\/a>\n
Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…<\/p>\n<\/li>\n
- \nBe aware of the deprecation of Smartsheet mobile app versions 10.8 and lower<\/a>\n
Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions 10.8 or older are no longer supported. If you haven't already done so, we strongly encourage you to update your mobile app to the latest version…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Announcements","componentName":"DiscussionListModule","componentProps":{"apiParams":{"pinned":true,"limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","sort":"-dateLastComment","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":112406,"type":"discussion","name":"NEW! Multi-widget editing in dashboards","excerpt":"Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of the widgets you select look uniform. You can access multi-widget editing by selecting more than one widget and clicking on the pencil icon to…","snippet":"Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of…","categoryID":335,"dateInserted":"2023-10-31T20:56:30+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T20:56:30+00:00","insertUserID":149137,"insertUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":149137,"lastUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":23,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":112406,"name":"NEW! Multi-widget editing in dashboards","url":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","dateInserted":"2023-10-31T20:56:30+00:00","insertUserID":149137,"insertUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png"},"alt":"Multi-widget editing.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":292,"urlcode":"dashboards","name":"Dashboards"}]},{"discussionID":112388,"type":"discussion","name":"Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center","excerpt":"Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume. To improve the experience and enable…","snippet":"Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these…","categoryID":335,"dateInserted":"2023-10-31T17:07:38+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T20:07:48+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":76736,"lastUser":{"userID":76736,"name":"Sarah Keortge","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Keortge","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pzVbKYHkoIQ!29HYv1nQZfw!6PeRZKuMdNC","dateLastActive":"2023-10-31T20:23:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":2,"countViews":40,"score":null,"hot":3397556126,"url":"https:\/\/community.smartsheet.com\/discussion\/112388\/be-aware-of-upcoming-changes-to-the-sheet-access-and-published-items-reports-in-admin-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112388\/be-aware-of-upcoming-changes-to-the-sheet-access-and-published-items-reports-in-admin-center","format":"Rich","lastPost":{"discussionID":112388,"commentID":402469,"name":"Re: Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402469#Comment_402469","dateInserted":"2023-10-31T20:07:48+00:00","insertUserID":76736,"insertUser":{"userID":76736,"name":"Sarah Keortge","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Keortge","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pzVbKYHkoIQ!29HYv1nQZfw!6PeRZKuMdNC","dateLastActive":"2023-10-31T20:23:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":112398,"type":"discussion","name":"Expanded Data Egress coverage for Smartsheet mobile app and public APIs now generally available!","excerpt":"Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable through the Smartsheet web and desktop applications, and not via the Smartsheet mobile app or public APIs. We’re excited to share that Smartsheet now…","snippet":"Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable…","categoryID":335,"dateInserted":"2023-10-31T19:07:13+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T19:07:13+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":84306,"lastUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":14,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","format":"Rich","lastPost":{"discussionID":112398,"name":"Expanded Data Egress coverage for Smartsheet mobile app and public APIs now generally available!","url":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","dateInserted":"2023-10-31T19:07:13+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":111063,"type":"discussion","name":"October Question of the Month 💭 Join the conversation and receive a badge","excerpt":"Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…","snippet":"Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that…","categoryID":346,"dateInserted":"2023-10-02T17:49:17+00:00","dateUpdated":"2023-10-11T17:11:27+00:00","dateLastComment":"2023-10-31T17:24:17+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/07K5KDBMGR8W\/nVJTUBA4JVX05.png","dateLastActive":"2023-10-31T21:02:56+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":124290,"lastUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-10-31T18:26:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":117,"countViews":1430,"score":null,"hot":3395112214,"url":"https:\/\/community.smartsheet.com\/discussion\/111063\/october-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111063\/october-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[324,441,493],"lastPost":{"discussionID":111063,"commentID":402417,"name":"Re: October Question of the Month 💭 Join the conversation and receive a badge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402417#Comment_402417","dateInserted":"2023-10-31T17:24:17+00:00","insertUserID":124290,"insertUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-10-31T18:26:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png"},"alt":"Community Question of the Months - Badges-10.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":["discussion","poll","question"]},"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":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":107697,"type":"discussion","name":"Be aware of the deprecation of Smartsheet mobile app versions 10.8 and lower","excerpt":"Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions 10.8 or older are no longer supported. If you haven't already done so, we strongly encourage you to update your mobile app to the latest version…","snippet":"Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions…","categoryID":335,"dateInserted":"2023-07-17T21:35:07+00:00","dateUpdated":"2023-10-20T17:01:39+00:00","dateLastComment":"2023-10-31T15:55:25+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":84306,"lastUserID":84306,"lastUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":225,"score":1,"hot":3384351531,"url":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","format":"Rich","lastPost":{"discussionID":107697,"name":"Be aware of the deprecation of Smartsheet mobile app versions 10.8 and lower","url":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","dateInserted":"2023-10-31T15:55:25+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":1}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&pinned=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":12,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n Recent Discussions<\/h2> <\/div>\n \n- \nJOIN(COLLECT<\/a>\n
Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n
- \nIf Statement Help<\/a>\n
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n
- \n48hr checkbox excluding weekends<\/a>\n
Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…<\/p>\n<\/li>\n
- \nHow to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc<\/a>\n
Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n
- \nAutomation workflow assigning people in a Contact List column - list doesn't match<\/a>\n
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, \"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","snippet":"Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = \"B\" from other reference sheet: Effective…","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112411,"name":"If Statement Help","url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","dateInserted":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112391,"type":"question","name":"48hr checkbox excluding weekends","excerpt":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…","snippet":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm…","categoryID":321,"dateInserted":"2023-10-31T18:08:48+00:00","dateUpdated":"2023-10-31T18:31:49+00:00","dateLastComment":"2023-10-31T22:47:51+00:00","insertUserID":169334,"insertUser":{"userID":169334,"name":"Portals","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Portals","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T18:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":169334,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3397569999,"url":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","format":"Rich","lastPost":{"discussionID":112391,"commentID":402492,"name":"Re: 48hr checkbox excluding weekends","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402492#Comment_402492","dateInserted":"2023-10-31T22:47:51+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:21:52+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","snippet":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","lastPost":{"discussionID":112410,"commentID":402491,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402491#Comment_402491","dateInserted":"2023-10-31T22:33:03+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112304,"type":"question","name":"Automation workflow assigning people in a Contact List column - list doesn't match","excerpt":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the \"Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…","snippet":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the…","categoryID":321,"dateInserted":"2023-10-28T00:58:51+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3397246632,"url":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","format":"Rich","tagIDs":[247,334,448,527],"lastPost":{"discussionID":112304,"commentID":402490,"name":"Re: Automation workflow assigning people in a Contact List column - list doesn't match","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402490#Comment_402490","dateInserted":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:18:21+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":247,"urlcode":"contacts","name":"Contacts"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":527,"urlcode":"columns","name":"columns"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"\n \n Newest Questions<\/h2> <\/div>\n \n- \nJOIN(COLLECT<\/a>\n
Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n
- \nIf Statement Help<\/a>\n
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n
- \nHow to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc<\/a>\n
Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n
- \nAuto export created attachment to local folder<\/a>\n
Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…<\/p>\n<\/li>\n
- \nPredict or set which row a form writes to<\/a>\n
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, \"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","snippet":"Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = \"B\" from other reference sheet: Effective…","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112411,"name":"If Statement Help","url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","dateInserted":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","snippet":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","lastPost":{"discussionID":112410,"commentID":402491,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402491#Comment_402491","dateInserted":"2023-10-31T22:33:03+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112409,"type":"question","name":"Auto export created attachment to local folder","excerpt":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…","snippet":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a…","categoryID":320,"dateInserted":"2023-10-31T21:32:47+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168221,"lastUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","format":"Rich","lastPost":{"discussionID":112409,"name":"Auto export created attachment to local folder","url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","dateInserted":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+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":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":112408,"type":"question","name":"Predict or set which row a form writes to","excerpt":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…","snippet":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the…","categoryID":321,"dateInserted":"2023-10-31T21:23:23+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:49:14+00:00","insertUserID":145797,"insertUser":{"userID":145797,"name":"Freymish","url":"https:\/\/community.smartsheet.com\/profile\/Freymish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GZADH7ZBQ6P2\/nGJT84EVC70D8.jpg","dateLastActive":"2023-10-31T21:23:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":7,"score":null,"hot":3397576957,"url":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":112408,"commentID":402489,"name":"Re: Predict or set which row a form writes to","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402489#Comment_402489","dateInserted":"2023-10-31T21:49:14+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:49:14+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
\"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","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":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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":112391,"type":"question","name":"48hr checkbox excluding weekends","excerpt":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…","categoryID":321,"dateInserted":"2023-10-31T18:08:48+00:00","dateUpdated":"2023-10-31T18:31:49+00:00","dateLastComment":"2023-10-31T22:47:51+00:00","insertUserID":169334,"insertUser":{"userID":169334,"name":"Portals","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Portals","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T18:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":169334,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3397569999,"url":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:21:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112304,"type":"question","name":"Automation workflow assigning people in a Contact List column - list doesn't match","excerpt":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the \"Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…","categoryID":321,"dateInserted":"2023-10-28T00:58:51+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3397246632,"url":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:18:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":527,"urlcode":"columns","name":"columns"}],"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":112408,"type":"question","name":"Predict or set which row a form writes to","excerpt":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…","categoryID":321,"dateInserted":"2023-10-31T21:23:23+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:49:14+00:00","insertUserID":145797,"insertUser":{"userID":145797,"name":"Freymish","url":"https:\/\/community.smartsheet.com\/profile\/Freymish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GZADH7ZBQ6P2\/nGJT84EVC70D8.jpg","dateLastActive":"2023-10-31T21:23:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":7,"score":null,"hot":3397576957,"url":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:49:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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":112392,"type":"question","name":"I am looking for a way to populate Sheet summary fields either through automations or control center","excerpt":"Use case is: From the Project intake process, move the row into the sheet summary fields.","categoryID":321,"dateInserted":"2023-10-31T18:12:42+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:44:29+00:00","insertUserID":169331,"insertUser":{"userID":169331,"name":"Doug.Swanson","url":"https:\/\/community.smartsheet.com\/profile\/Doug.Swanson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:31:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":169331,"lastUser":{"userID":169331,"name":"Doug.Swanson","url":"https:\/\/community.smartsheet.com\/profile\/Doug.Swanson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:31:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":35,"score":null,"hot":3397570031,"url":"https:\/\/community.smartsheet.com\/discussion\/112392\/i-am-looking-for-a-way-to-populate-sheet-summary-fields-either-through-automations-or-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112392\/i-am-looking-for-a-way-to-populate-sheet-summary-fields-either-through-automations-or-control-center","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:18:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112334,"type":"question","name":"generate an automatic sequential numbering system under the WBS column","excerpt":"This discussion was created from comments split from: Respective cells get blank.","categoryID":321,"dateInserted":"2023-10-30T16:34:10+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:33:51+00:00","insertUserID":113652,"insertUser":{"userID":113652,"name":"System","title":"","url":"https:\/\/community.smartsheet.com\/profile\/System","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/650\/n67RVONBT7K0D.png","dateLastActive":"2023-10-26T19:11:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":139601,"lastUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"jmyzk","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-10-31T21:26:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":31,"score":null,"hot":3397475281,"url":"https:\/\/community.smartsheet.com\/discussion\/112334\/generate-an-automatic-sequential-numbering-system-under-the-wbs-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112334\/generate-an-automatic-sequential-numbering-system-under-the-wbs-column","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T02:32:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112409,"type":"question","name":"Auto export created attachment to local folder","excerpt":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…","categoryID":320,"dateInserted":"2023-10-31T21:32:47+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168221,"lastUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[],"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":112367,"type":"question","name":"What happens when the attribute names (column names) are changed?","excerpt":"We have a few dashboards which use the data from certain attributes (columns) in a sheet. We've recently decided to change the names of these attributes. What will the impact be on the dashboards be? + Is there an effective way to change the column names in all the cells that reference said columns at once instead of going…","categoryID":321,"dateInserted":"2023-10-31T12:15:15+00:00","dateUpdated":"2023-10-31T12:34:12+00:00","dateLastComment":"2023-10-31T21:27:36+00:00","insertUserID":169222,"insertUser":{"userID":169222,"name":"soumyae","title":"Specialist - TECH Project Management","url":"https:\/\/community.smartsheet.com\/profile\/soumyae","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T20:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3397543371,"url":"https:\/\/community.smartsheet.com\/discussion\/112367\/what-happens-when-the-attribute-names-column-names-are-changed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112367\/what-happens-when-the-attribute-names-column-names-are-changed","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:27:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":527,"urlcode":"columns","name":"columns"}],"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}">
Categories
Popular Tags
- Formulas11,080
- Project Management4,422
- Sheets3,808
- Reports2,687
- 形式2,476
- functionality2,202
- Automations2,009
- IT & Operations1,755
- Enhancement Request1,591
- Support1,568
- Cell linking1,564
- Email Notifications1,474
- Account and User Management1,407
- Dashboards1,304
- Integrations1,256
- Conditional Formatting1,230
- Construction1,094
- API and Developers945
- Sharing and Collaboration919
- Workflows in Smartsheet900
- Manufacturing865
- Update Requests851
- Gantt View806
- Product Development802
- Attachments799
This Week's Leaders
This Month's Leaders
Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of the widgets you select look uniform. You can access multi-widget editing by selecting more than one widget and clicking on the pencil icon to…<\/p>\n<\/li>\n
Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume. To improve the experience and enable…<\/p>\n<\/li>\n
Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable through the Smartsheet web and desktop applications, and not via the Smartsheet mobile app or public APIs. We’re excited to share that Smartsheet now…<\/p>\n<\/li>\n
Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…<\/p>\n<\/li>\n
Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions 10.8 or older are no longer supported. If you haven't already done so, we strongly encourage you to update your mobile app to the latest version…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Announcements","componentName":"DiscussionListModule","componentProps":{"apiParams":{"pinned":true,"limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","sort":"-dateLastComment","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":112406,"type":"discussion","name":"NEW! Multi-widget editing in dashboards","excerpt":"Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of the widgets you select look uniform. You can access multi-widget editing by selecting more than one widget and clicking on the pencil icon to…","snippet":"Hey Community! New feature alert! Multi-widget editing allows you to modify multiple dashboard widgets simultaneously, which saves a considerable amount of time and ensures all of…","categoryID":335,"dateInserted":"2023-10-31T20:56:30+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T20:56:30+00:00","insertUserID":149137,"insertUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":149137,"lastUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":23,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":112406,"name":"NEW! Multi-widget editing in dashboards","url":"https:\/\/community.smartsheet.com\/discussion\/112406\/new-multi-widget-editing-in-dashboards","dateInserted":"2023-10-31T20:56:30+00:00","insertUserID":149137,"insertUser":{"userID":149137,"name":"Jason DelValle","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20DelValle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-w9oN_MAHns!2rlov9PkVrs!IZIII8oUpLM","dateLastActive":"2023-10-31T22:02:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/867P19BNYGPS\/multi-widget-editing.png"},"alt":"Multi-widget editing.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":292,"urlcode":"dashboards","name":"Dashboards"}]},{"discussionID":112388,"type":"discussion","name":"Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center","excerpt":"Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume. To improve the experience and enable…","snippet":"Hi Community, We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center. Today, these…","categoryID":335,"dateInserted":"2023-10-31T17:07:38+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T20:07:48+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":76736,"lastUser":{"userID":76736,"name":"Sarah Keortge","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Keortge","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pzVbKYHkoIQ!29HYv1nQZfw!6PeRZKuMdNC","dateLastActive":"2023-10-31T20:23:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":2,"countViews":40,"score":null,"hot":3397556126,"url":"https:\/\/community.smartsheet.com\/discussion\/112388\/be-aware-of-upcoming-changes-to-the-sheet-access-and-published-items-reports-in-admin-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112388\/be-aware-of-upcoming-changes-to-the-sheet-access-and-published-items-reports-in-admin-center","format":"Rich","lastPost":{"discussionID":112388,"commentID":402469,"name":"Re: Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402469#Comment_402469","dateInserted":"2023-10-31T20:07:48+00:00","insertUserID":76736,"insertUser":{"userID":76736,"name":"Sarah Keortge","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Keortge","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pzVbKYHkoIQ!29HYv1nQZfw!6PeRZKuMdNC","dateLastActive":"2023-10-31T20:23:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":112398,"type":"discussion","name":"Expanded Data Egress coverage for Smartsheet mobile app and public APIs now generally available!","excerpt":"Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable through the Smartsheet web and desktop applications, and not via the Smartsheet mobile app or public APIs. We’re excited to share that Smartsheet now…","snippet":"Hi Community, With Data Egress, System Administrators can restrict actions that allow data to leave their Smartsheet account. Previously, these policies were only enforceable…","categoryID":335,"dateInserted":"2023-10-31T19:07:13+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T19:07:13+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":84306,"lastUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":14,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","format":"Rich","lastPost":{"discussionID":112398,"name":"Expanded Data Egress coverage for Smartsheet mobile app and public APIs now generally available!","url":"https:\/\/community.smartsheet.com\/discussion\/112398\/expanded-data-egress-coverage-for-smartsheet-mobile-app-and-public-apis-now-generally-available","dateInserted":"2023-10-31T19:07:13+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":111063,"type":"discussion","name":"October Question of the Month 💭 Join the conversation and receive a badge","excerpt":"Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that scared you until you did it? Could be joining a new company, taking on a new project, sky diving or something else. Drop your answer in the…","snippet":"Hi everyone, We're ready to kick off October with a new question and opportunity for you to earn some badges and points while getting to know your peers! What is one thing that…","categoryID":346,"dateInserted":"2023-10-02T17:49:17+00:00","dateUpdated":"2023-10-11T17:11:27+00:00","dateLastComment":"2023-10-31T17:24:17+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/07K5KDBMGR8W\/nVJTUBA4JVX05.png","dateLastActive":"2023-10-31T21:02:56+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":124290,"lastUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-10-31T18:26:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":117,"countViews":1430,"score":null,"hot":3395112214,"url":"https:\/\/community.smartsheet.com\/discussion\/111063\/october-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111063\/october-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[324,441,493],"lastPost":{"discussionID":111063,"commentID":402417,"name":"Re: October Question of the Month 💭 Join the conversation and receive a badge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402417#Comment_402417","dateInserted":"2023-10-31T17:24:17+00:00","insertUserID":124290,"insertUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-10-31T18:26:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/W8ACQ94689LL\/community-question-of-the-months-badges-10.png"},"alt":"Community Question of the Months - Badges-10.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":["discussion","poll","question"]},"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":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":107697,"type":"discussion","name":"Be aware of the deprecation of Smartsheet mobile app versions 10.8 and lower","excerpt":"Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions 10.8 or older are no longer supported. If you haven't already done so, we strongly encourage you to update your mobile app to the latest version…","snippet":"Hi Community, We would like to inform you that Smartsheet deprecated the older versions of the mobile app on October 18, 2023. Please note that all Smartsheet mobile app versions…","categoryID":335,"dateInserted":"2023-07-17T21:35:07+00:00","dateUpdated":"2023-10-20T17:01:39+00:00","dateLastComment":"2023-10-31T15:55:25+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":84306,"lastUserID":84306,"lastUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":225,"score":1,"hot":3384351531,"url":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","format":"Rich","lastPost":{"discussionID":107697,"name":"Be aware of the deprecation of Smartsheet mobile app versions 10.8 and lower","url":"https:\/\/community.smartsheet.com\/discussion\/107697\/be-aware-of-the-deprecation-of-smartsheet-mobile-app-versions-10-8-and-lower","dateInserted":"2023-10-31T15:55:25+00:00","insertUserID":84306,"insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-10-31T19:06:06+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcements"},{"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":1}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&pinned=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":12,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
Recent Discussions<\/h2> <\/div>\n \n- \nJOIN(COLLECT<\/a>\n
Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n
- \nIf Statement Help<\/a>\n
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n
- \n48hr checkbox excluding weekends<\/a>\n
Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…<\/p>\n<\/li>\n
- \nHow to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc<\/a>\n
Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n
- \nAutomation workflow assigning people in a Contact List column - list doesn't match<\/a>\n
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, \"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","snippet":"Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = \"B\" from other reference sheet: Effective…","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112411,"name":"If Statement Help","url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","dateInserted":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112391,"type":"question","name":"48hr checkbox excluding weekends","excerpt":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…","snippet":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm…","categoryID":321,"dateInserted":"2023-10-31T18:08:48+00:00","dateUpdated":"2023-10-31T18:31:49+00:00","dateLastComment":"2023-10-31T22:47:51+00:00","insertUserID":169334,"insertUser":{"userID":169334,"name":"Portals","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Portals","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T18:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":169334,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3397569999,"url":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","format":"Rich","lastPost":{"discussionID":112391,"commentID":402492,"name":"Re: 48hr checkbox excluding weekends","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402492#Comment_402492","dateInserted":"2023-10-31T22:47:51+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:21:52+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","snippet":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","lastPost":{"discussionID":112410,"commentID":402491,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402491#Comment_402491","dateInserted":"2023-10-31T22:33:03+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112304,"type":"question","name":"Automation workflow assigning people in a Contact List column - list doesn't match","excerpt":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the \"Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…","snippet":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the…","categoryID":321,"dateInserted":"2023-10-28T00:58:51+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3397246632,"url":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","format":"Rich","tagIDs":[247,334,448,527],"lastPost":{"discussionID":112304,"commentID":402490,"name":"Re: Automation workflow assigning people in a Contact List column - list doesn't match","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402490#Comment_402490","dateInserted":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:18:21+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":247,"urlcode":"contacts","name":"Contacts"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":527,"urlcode":"columns","name":"columns"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"\n \n Newest Questions<\/h2> <\/div>\n \n- \nJOIN(COLLECT<\/a>\n
Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n
- \nIf Statement Help<\/a>\n
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n
- \nHow to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc<\/a>\n
Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n
- \nAuto export created attachment to local folder<\/a>\n
Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…<\/p>\n<\/li>\n
- \nPredict or set which row a form writes to<\/a>\n
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, \"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","snippet":"Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = \"B\" from other reference sheet: Effective…","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112411,"name":"If Statement Help","url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","dateInserted":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","snippet":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","lastPost":{"discussionID":112410,"commentID":402491,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402491#Comment_402491","dateInserted":"2023-10-31T22:33:03+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":112409,"type":"question","name":"Auto export created attachment to local folder","excerpt":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…","snippet":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a…","categoryID":320,"dateInserted":"2023-10-31T21:32:47+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168221,"lastUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","format":"Rich","lastPost":{"discussionID":112409,"name":"Auto export created attachment to local folder","url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","dateInserted":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+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":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":112408,"type":"question","name":"Predict or set which row a form writes to","excerpt":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…","snippet":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the…","categoryID":321,"dateInserted":"2023-10-31T21:23:23+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:49:14+00:00","insertUserID":145797,"insertUser":{"userID":145797,"name":"Freymish","url":"https:\/\/community.smartsheet.com\/profile\/Freymish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GZADH7ZBQ6P2\/nGJT84EVC70D8.jpg","dateLastActive":"2023-10-31T21:23:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":7,"score":null,"hot":3397576957,"url":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":112408,"commentID":402489,"name":"Re: Predict or set which row a form writes to","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402489#Comment_402489","dateInserted":"2023-10-31T21:49:14+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:49:14+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"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":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
\"//www.santa-greenland.com/community/\", \"Yes\", \"No\")","categoryID":322,"dateInserted":"2023-10-31T22:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:48:28+00:00","insertUserID":168660,"insertUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":168660,"lastUser":{"userID":168660,"name":"nhornCGT","title":"Performance Director","url":"https:\/\/community.smartsheet.com\/profile\/nhornCGT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k61EX4lgR0Y!!1ZMPeKRcGRq","dateLastActive":"2023-10-31T22:48:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112411\/if-statement-help","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","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":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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":112391,"type":"question","name":"48hr checkbox excluding weekends","excerpt":"Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…","categoryID":321,"dateInserted":"2023-10-31T18:08:48+00:00","dateUpdated":"2023-10-31T18:31:49+00:00","dateLastComment":"2023-10-31T22:47:51+00:00","insertUserID":169334,"insertUser":{"userID":169334,"name":"Portals","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Portals","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T18:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":169334,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3397569999,"url":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112391\/48hr-checkbox-excluding-weekends","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:21:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112410,"type":"question","name":"How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","excerpt":"Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…","categoryID":322,"dateInserted":"2023-10-31T21:55:12+00:00","dateUpdated":"2023-10-31T22:09:27+00:00","dateLastComment":"2023-10-31T22:33:03+00:00","insertUserID":163733,"insertUser":{"userID":163733,"name":"Seb_Mar","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Seb_Mar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TI92V6OMSB71\/nBNSQVFM1556D.jpg","dateLastActive":"2023-10-31T22:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3397581495,"url":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112410\/how-to-populate-information-on-specific-columns-based-on-frequencies-i-e-quarterly-monthly-etc","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/NKFFYUBMJDIK\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:33:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112304,"type":"question","name":"Automation workflow assigning people in a Contact List column - list doesn't match","excerpt":"Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the \"Assign People\" action and the \"Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…","categoryID":321,"dateInserted":"2023-10-28T00:58:51+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T22:18:21+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T22:50:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3397246632,"url":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112304\/automation-workflow-assigning-people-in-a-contact-list-column-list-doesnt-match","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T22:18:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":527,"urlcode":"columns","name":"columns"}],"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":112408,"type":"question","name":"Predict or set which row a form writes to","excerpt":"I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…","categoryID":321,"dateInserted":"2023-10-31T21:23:23+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:49:14+00:00","insertUserID":145797,"insertUser":{"userID":145797,"name":"Freymish","url":"https:\/\/community.smartsheet.com\/profile\/Freymish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GZADH7ZBQ6P2\/nGJT84EVC70D8.jpg","dateLastActive":"2023-10-31T21:23:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":7,"score":null,"hot":3397576957,"url":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112408\/predict-or-set-which-row-a-form-writes-to","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:49:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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":112392,"type":"question","name":"I am looking for a way to populate Sheet summary fields either through automations or control center","excerpt":"Use case is: From the Project intake process, move the row into the sheet summary fields.","categoryID":321,"dateInserted":"2023-10-31T18:12:42+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:44:29+00:00","insertUserID":169331,"insertUser":{"userID":169331,"name":"Doug.Swanson","url":"https:\/\/community.smartsheet.com\/profile\/Doug.Swanson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:31:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":169331,"lastUser":{"userID":169331,"name":"Doug.Swanson","url":"https:\/\/community.smartsheet.com\/profile\/Doug.Swanson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:31:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":35,"score":null,"hot":3397570031,"url":"https:\/\/community.smartsheet.com\/discussion\/112392\/i-am-looking-for-a-way-to-populate-sheet-summary-fields-either-through-automations-or-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112392\/i-am-looking-for-a-way-to-populate-sheet-summary-fields-either-through-automations-or-control-center","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T18:18:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112334,"type":"question","name":"generate an automatic sequential numbering system under the WBS column","excerpt":"This discussion was created from comments split from: Respective cells get blank.","categoryID":321,"dateInserted":"2023-10-30T16:34:10+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:33:51+00:00","insertUserID":113652,"insertUser":{"userID":113652,"name":"System","title":"","url":"https:\/\/community.smartsheet.com\/profile\/System","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/650\/n67RVONBT7K0D.png","dateLastActive":"2023-10-26T19:11:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":139601,"lastUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"jmyzk","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-10-31T21:26:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":31,"score":null,"hot":3397475281,"url":"https:\/\/community.smartsheet.com\/discussion\/112334\/generate-an-automatic-sequential-numbering-system-under-the-wbs-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112334\/generate-an-automatic-sequential-numbering-system-under-the-wbs-column","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T02:32:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[],"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":112409,"type":"question","name":"Auto export created attachment to local folder","excerpt":"Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…","categoryID":320,"dateInserted":"2023-10-31T21:32:47+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T21:32:47+00:00","insertUserID":168221,"insertUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168221,"lastUser":{"userID":168221,"name":"dhallarcosa","title":"Materials Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhallarcosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T21:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112409\/auto-export-created-attachment-to-local-folder","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[],"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":112367,"type":"question","name":"What happens when the attribute names (column names) are changed?","excerpt":"We have a few dashboards which use the data from certain attributes (columns) in a sheet. We've recently decided to change the names of these attributes. What will the impact be on the dashboards be? + Is there an effective way to change the column names in all the cells that reference said columns at once instead of going…","categoryID":321,"dateInserted":"2023-10-31T12:15:15+00:00","dateUpdated":"2023-10-31T12:34:12+00:00","dateLastComment":"2023-10-31T21:27:36+00:00","insertUserID":169222,"insertUser":{"userID":169222,"name":"soumyae","title":"Specialist - TECH Project Management","url":"https:\/\/community.smartsheet.com\/profile\/soumyae","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-31T20:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":146304,"lastUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BILygZsiKro!BhawQTdaN4g!kpsDfoN5YKE","dateLastActive":"2023-10-31T22:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3397543371,"url":"https:\/\/community.smartsheet.com\/discussion\/112367\/what-happens-when-the-attribute-names-column-names-are-changed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112367\/what-happens-when-the-attribute-names-column-names-are-changed","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-31T21:27:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":527,"urlcode":"columns","name":"columns"}],"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}">
Categories
Popular Tags
- Formulas11,080
- Project Management4,422
- Sheets3,808
- Reports2,687
- 形式2,476
- functionality2,202
- Automations2,009
- IT & Operations1,755
- Enhancement Request1,591
- Support1,568
- Cell linking1,564
- Email Notifications1,474
- Account and User Management1,407
- Dashboards1,304
- Integrations1,256
- Conditional Formatting1,230
- Construction1,094
- API and Developers945
- Sharing and Collaboration919
- Workflows in Smartsheet900
- Manufacturing865
- Update Requests851
- Gantt View806
- Product Development802
- Attachments799
This Week's Leaders
This Month's Leaders
Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n
Hi, I currently have a formula to tick a box after 48 hours but I need it to exclude weekends. The problem is it's a live workflow and I'm reluctant to make changes unless I'm 100% sure. My current formula is: =IF((TODAY() - [input date column]@row) > 2, 1, 0) I was thinking something like this: =IF((WORKDAY() - [input…<\/p>\n<\/li>\n
Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, <TODAY-7, "-") Objective: I want the formula to search the meeting minutes sheet (pic 2) to match the pursuit # column…<\/p>\n<\/li>\n Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")<\/p>\n<\/li>\n Hello, Is there a way to write a formula that would populate a calculation based on a project's invoice frequency? I had to duplicate the Column titles in the first row so I could use those dates. I was able to get a result for a basic calculation, see below: =IF(AND(YEAR($[Imp Date]@row) = VALUE(RIGHT([1\/31\/23]$1, 4)),…<\/p>\n<\/li>\n Is there a way to automatically save\/export a created document to a local folder? I have a .pdf that is generated through a workflow, but I need the pdf generated also saved in a local folder with a file name specific to the generated document (Equip#_Created Date) For example, I have a folder for a specific piece of…<\/p>\n<\/li>\n I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index\/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":112412,"type":"question","name":"JOIN(COLLECT","excerpt":"Hi, I'm trying to use the join collect formula (example of my formula currently) =JOIN(COLLECT({Meeting Minutes Topic & AI}, {Meeting Minutes Pursuit #}, [Pursuit #]@row, {Meeting Minutes Updated Date}, Newest Questions<\/h2> <\/div>\n
\n
Explore. Ask. Answer
Discussion List
Categories
Popular Tags
This Week's Leaders
This Month's Leaders