Explore. Ask. Answer

When humans are connected, aligned, and supported,
they can focus and reach their full potential

Learn more

Areas to explore

About the Smartsheet Community
Get a quick tour and check out all the benefits of logging in.

Browse discussions
See what’s been recently shared and join those conversations that interest you.

Earn Badges + Swag
Let’s celebrate! Join now and start earning points, badges, and Smartsheet swag.

Share your ideas
Tell us about the product improvements you want to see and vote on existing ideas.

Get Help with Smartsheet
Find answers to your Smartsheet questions and quick links to helpful resources.

Show & Tell
Share and celebrate - whether a promotion, a new Smartsheet solution, best practice or badge. Share the good news and cheer on others!

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
\n Be 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
\n Expanded 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
\n October 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
\n Be 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":29,"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":42,"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":16,"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-31T23:48:52+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":1433,"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
\n How to address column restriction error and value does not conform to req for PICKLIST?<\/a>\n
Within Data Shuttle, 4 days ago I started having Data Shuttle workflows that would not work. I am trying to upload data from an excel sheet that is housed in one of my other Smartsheets. The workflow error states "Unable to update row in target sheet : CELL_VALUE_FAILS_VALIDATION: The value for cell in column 9950538889…<\/p>\n<\/li>\n
\n Alphabetisation<\/a>\n
Hi, does anyone have any ideas to achieve consistent results in alphabetisation? The example I have is that I have taken over a number of projects and I am trying to add in links to set-up automation etc. I have a list of folders, eg Pama... Pamb... PAM che.. In the Browse view they are in this order, yet when adding links…<\/p>\n<\/li>\n
\n Auto sort<\/a>\n
Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…<\/p>\n<\/li>\n
\n Dynamic View Comments notifications for user without access to source sheet<\/a>\n
Unfortunately, because Dynamic view does not support @mention for users not shared with the source sheet, this means that my 700+ users have to revert to email. Is there a timeline for this feature to be added? Thanks<\/p>\n<\/li>\n
\n How 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<\/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":112401,"type":"question","name":"How to address column restriction error and value does not conform to req for PICKLIST?","excerpt":"Within Data Shuttle, 4 days ago I started having Data Shuttle workflows that would not work. I am trying to upload data from an excel sheet that is housed in one of my other Smartsheets. The workflow error states \"Unable to update row in target sheet : CELL_VALUE_FAILS_VALIDATION: The value for cell in column 9950538889…","snippet":"Within Data Shuttle, 4 days ago I started having Data Shuttle workflows that would not work. I am trying to upload data from an excel sheet that is housed in one of my other…","categoryID":320,"dateInserted":"2023-10-31T19:27:35+00:00","dateUpdated":null,"dateLastComment":"2023-11-01T01:11:56+00:00","insertUserID":166539,"insertUser":{"userID":166539,"name":"jshrum","title":"Associate Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/jshrum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:02:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166539,"lastUser":{"userID":166539,"name":"jshrum","title":"Associate Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/jshrum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:02:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":null,"hot":3397582171,"url":"https:\/\/community.smartsheet.com\/discussion\/112401\/how-to-address-column-restriction-error-and-value-does-not-conform-to-req-for-picklist","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112401\/how-to-address-column-restriction-error-and-value-does-not-conform-to-req-for-picklist","format":"Rich","lastPost":{"discussionID":112401,"commentID":402497,"name":"Re: How to address column restriction error and value does not conform to req for PICKLIST?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402497#Comment_402497","dateInserted":"2023-11-01T01:11:56+00:00","insertUserID":166539,"insertUser":{"userID":166539,"name":"jshrum","title":"Associate Director of Operations","url":"https:\/\/community.smartsheet.com\/profile\/jshrum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:02:30+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-11-01T01:11:56+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","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":112316,"type":"question","name":"Alphabetisation","excerpt":"Hi, does anyone have any ideas to achieve consistent results in alphabetisation? The example I have is that I have taken over a number of projects and I am trying to add in links to set-up automation etc. I have a list of folders, eg Pama... Pamb... PAM che.. In the Browse view they are in this order, yet when adding links…","snippet":"Hi, does anyone have any ideas to achieve consistent results in alphabetisation? The example I have is that I have taken over a number of projects and I am trying to add in links…","categoryID":321,"dateInserted":"2023-10-30T01:23:46+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T23:48:07+00:00","insertUserID":168825,"insertUser":{"userID":168825,"name":"PM_Reeves","url":"https:\/\/community.smartsheet.com\/profile\/PM_Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:44:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168825,"lastUser":{"userID":168825,"name":"PM_Reeves","url":"https:\/\/community.smartsheet.com\/profile\/PM_Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:44:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3397426313,"url":"https:\/\/community.smartsheet.com\/discussion\/112316\/alphabetisation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112316\/alphabetisation","format":"Rich","lastPost":{"discussionID":112316,"commentID":402496,"name":"Re: Alphabetisation","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402496#Comment_402496","dateInserted":"2023-10-31T23:48:07+00:00","insertUserID":168825,"insertUser":{"userID":168825,"name":"PM_Reeves","url":"https:\/\/community.smartsheet.com\/profile\/PM_Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T01:44:52+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-31T19:01:00+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":112413,"type":"question","name":"Auto sort","excerpt":"Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…","snippet":"Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that…","categoryID":321,"dateInserted":"2023-10-31T23:39:53+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T23:39:53+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":165479,"lastUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","format":"Rich","tagIDs":[219,245,319,334,507],"lastPost":{"discussionID":112413,"name":"Auto sort","url":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","dateInserted":"2023-10-31T23:39:53+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":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":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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}]},{"discussionID":105161,"type":"idea","name":"Dynamic View Comments notifications for user without access to source sheet","excerpt":"Unfortunately, because Dynamic view does not support @mention for users not shared with the source sheet, this means that my 700+ users have to revert to email. Is there a timeline for this feature to be added? Thanks","snippet":"Unfortunately, because Dynamic view does not support @mention for users not shared with the source sheet, this means that my 700+ users have to revert to email. Is there a…","categoryID":349,"dateInserted":"2023-05-12T00:08:44+00:00","dateUpdated":"2023-09-27T09:44:19+00:00","dateLastComment":"2023-10-31T23:11:48+00:00","insertUserID":149700,"insertUser":{"userID":149700,"name":"Peter F.","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20F.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zA8ps0eDxns!bIvq2yv4TbM!n6piQSU_I-7","dateLastActive":"2023-08-03T19:53:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":148288,"lastUser":{"userID":148288,"name":"Adam Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Adam%20Murphy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hYm04QUgMrg!7Qnxe0t6TrI!m3vIjRv0FJK","dateLastActive":"2023-10-31T23:17:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":472,"score":26,"hot":3382660232,"url":"https:\/\/community.smartsheet.com\/discussion\/105161\/dynamic-view-comments-notifications-for-user-without-access-to-source-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105161\/dynamic-view-comments-notifications-for-user-without-access-to-source-sheet","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":105161,"commentID":402495,"name":"Re: Dynamic View Comments notifications for user without access to source sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402495#Comment_402495","dateInserted":"2023-10-31T23:11:48+00:00","insertUserID":148288,"insertUser":{"userID":148288,"name":"Adam Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Adam%20Murphy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hYm04QUgMrg!7Qnxe0t6TrI!m3vIjRv0FJK","dateLastActive":"2023-10-31T23:17:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":26}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"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-31T23:05:55+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-11-01T01:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":163733,"lastUser":{"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-11-01T01:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3397584067,"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":402494,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402494#Comment_402494","dateInserted":"2023-10-31T23:05:55+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-11-01T01:06:50+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":[]}],"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
\n Auto sort<\/a>\n
Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…<\/p>\n<\/li>\n
\n JOIN(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
\n If 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
\n How 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
\n Auto 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<\/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":112413,"type":"question","name":"Auto sort","excerpt":"Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…","snippet":"Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that…","categoryID":321,"dateInserted":"2023-10-31T23:39:53+00:00","dateUpdated":null,"dateLastComment":"2023-10-31T23:39:53+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":165479,"lastUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","format":"Rich","tagIDs":[219,245,319,334,507],"lastPost":{"discussionID":112413,"name":"Auto sort","url":"https:\/\/community.smartsheet.com\/discussion\/112413\/auto-sort","dateInserted":"2023-10-31T23:39:53+00:00","insertUserID":165479,"insertUser":{"userID":165479,"name":"Chris_Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-11-01T00:18:03+00:00","banned":0,"punished":0,"private":true,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":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":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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}]},{"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/\", \"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":13,"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-31T23:05:55+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-11-01T01:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163733,"lastUserID":163733,"lastUser":{"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-11-01T01:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3397584067,"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":402494,"name":"Re: How to populate information on specific columns based on frequencies i.e. Quarterly, Monthly, etc","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402494#Comment_402494","dateInserted":"2023-10-31T23:05:55+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-11-01T01:06:50+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":15,"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":[]}],"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.

« 1 2 3 4 5 6 7 … 100 »

Discussion List

\"//www.santa-greenland.com/\", \"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":13,"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:55:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"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":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:55:35+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:55:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":30,"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":4,"attributes":{"question":{"status":"rejected","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":["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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

« 1 2 3 4 5 6 7 … 100 »

Hey!You will be signed out in60seconds due to inactivity.Click here to continue using the site.

Popular Tags

Member Spotlight

"Be as clear as possible in both your questions and your answers here [in Community]. Also, if the conversation is becoming more than one or two exchanges, check out the other person's signature block and reach out to them offline for more detailed discussions. And then don't forget to recap it back on the forum thread to explain the outcome so others can learn as well."