Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both insightful and creative. We're kicking off July with a new questions and another opportunity for you to earn badges and points while getting to know…<\/p>\n<\/li>\n
Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn more about cell links. Catch up on how Smartsheet is investing in scale and reliability by reading VP of Engineering Gihan Munasinghe's recent…<\/p>\n<\/li>\n
Last week we received some exciting news, thanks to you, our customers! Smartsheet received the distinction of being Customers’ Choice in the 2023 Gartner Peer Insights ‘Voice of the Customer’ in the Collaborative Work Management market. In fact, 98% of Smartsheet customers said they would recommend the platform. This…<\/p>\n<\/li>\n
Hi Community, We updated the sheet picker UI used to specify the destination sheet for move and copy row automated workflows. The new sheet picker UI is faster and more consistent with other areas of the product, like Search and Reports. Licensed users on all Commercial US and Commercial EU plans will have access to the…<\/p>\n<\/li>\n
Smartsheet and McLaren Racing are teaming up to showcase STEAM Co. on the tracks at the British Grand Prix. And you, our members can join the conversation and help shine a light on this deserving nonprofit that inspires children and ignites creativity in our schools, our work, and our lives with their resounding message to…<\/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","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":107188,"type":"question","name":"July Question of the Month 💭 Join the conversation and receive a badge!","excerpt":"Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both insightful and creative. We're kicking off July with a new questions and another opportunity for you to earn badges and points while getting to know…","snippet":"Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both…","categoryID":346,"dateInserted":"2023-07-03T18:32:48+00:00","dateUpdated":"2023-07-06T17:20:12+00:00","dateLastComment":"2023-07-17T01:40:14+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-07-14T18:38:45+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":158672,"lastUser":{"userID":158672,"name":"Rachel Martin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rachel%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/WBPQOPI4NUPG\/n0367C5WQO010.jpeg","dateLastActive":"2023-07-17T01:15:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":100,"countViews":955,"score":5,"hot":3378028682,"url":"https:\/\/community.smartsheet.com\/discussion\/107188\/july-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107188\/july-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[493],"lastPost":{"discussionID":107188,"commentID":385495,"name":"Re: July Question of the Month 💭 Join the conversation and receive a badge!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385495#Comment_385495","dateInserted":"2023-07-17T01:40:14+00:00","insertUserID":158672,"insertUser":{"userID":158672,"name":"Rachel Martin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rachel%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/WBPQOPI4NUPG\/n0367C5WQO010.jpeg","dateLastActive":"2023-07-17T01:15:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/lh6.googleusercontent.com\/RRWg66zXQZMOazwkF0W3pdxUJKtK6zI7oz_lHB-w3I9YtULm0c8GmhjsxDEXSOaDnIfL7XH5h4u6pxgxB2_3KZRWTcyoc136y-I7KsPPccUxtmN7mH5WOC5IJ11I5quxC_gAqFhDq1HaAaNfudOEEdg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"RRWg66zXQZMOazwkF0W3pdxUJKtK6zI7oz_lHB-w3I9YtULm0c8GmhjsxDEXSOaDnIfL7XH5h4u6pxgxB2_3KZRWTcyoc136y-I7KsPPccUxtmN7mH5WOC5IJ11I5quxC_gAqFhDq1HaAaNfudOEEdg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-03T19:33:28+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":4}],"tags":[{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":106993,"type":"discussion","name":"Limit increase: 500,000 inbound cell links","excerpt":"Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn more about cell links. Catch up on how Smartsheet is investing in scale and reliability by reading VP of Engineering Gihan Munasinghe's recent…","snippet":"Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn…","categoryID":335,"dateInserted":"2023-06-28T03:02:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-15T15:01:22+00:00","insertUserID":145085,"insertUser":{"userID":145085,"name":"Allegra Silcox","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Allegra%20Silcox","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!btnWmx2hXT4!nevWPz3DEL4!dfcwT6jINFw","dateLastActive":"2023-07-16T22:48:39+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DKTEWPYCU2OY\/nBJQNCZXABT0R.png","dateLastActive":"2023-07-17T03:51:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":11,"countViews":265,"score":10,"hot":3377364218,"url":"https:\/\/community.smartsheet.com\/discussion\/106993\/limit-increase-500-000-inbound-cell-links","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106993\/limit-increase-500-000-inbound-cell-links","format":"Rich","tagIDs":[472],"lastPost":{"discussionID":106993,"commentID":385467,"name":"Re: Limit increase: 500,000 inbound cell links","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385467#Comment_385467","dateInserted":"2023-07-15T15:01:22+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DKTEWPYCU2OY\/nBJQNCZXABT0R.png","dateLastActive":"2023-07-17T03:51:05+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FAQAA58X6XB7\/reliability-scale-blog-info1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Reliability-Scale-blog-info1.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":10}],"tags":[{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]},{"discussionID":107422,"type":"discussion","name":"Join us as we celebrate Gartner Peer Insights Customers' Choice 2023 🥳 Enter to win swag","excerpt":"Last week we received some exciting news, thanks to you, our customers! Smartsheet received the distinction of being Customers’ Choice in the 2023 Gartner Peer Insights ‘Voice of the Customer’ in the Collaborative Work Management market. In fact, 98% of Smartsheet customers said they would recommend the platform. This…","snippet":"Last week we received some exciting news, thanks to you, our customers! Smartsheet received the distinction of being Customers’ Choice in the 2023 Gartner Peer Insights ‘Voice of…","categoryID":346,"dateInserted":"2023-07-10T20:57:02+00:00","dateUpdated":"2023-07-10T23:55:09+00:00","dateLastComment":"2023-07-14T22:46:13+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-07-14T18:38:45+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":145232,"lastUserID":151354,"lastUser":{"userID":151354,"name":"ValerieSD","url":"https:\/\/community.smartsheet.com\/profile\/ValerieSD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jMFXI6NkxPs!5OfW-X9-Zj0!VzIuv5dqAYE","dateLastActive":"2023-07-14T23:01:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":17,"countViews":180,"score":2,"hot":3378408195,"url":"https:\/\/community.smartsheet.com\/discussion\/107422\/join-us-as-we-celebrate-gartner-peer-insights-customers-choice-2023-enter-to-win-swag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107422\/join-us-as-we-celebrate-gartner-peer-insights-customers-choice-2023-enter-to-win-swag","format":"Rich","tagIDs":[458],"lastPost":{"discussionID":107422,"commentID":385445,"name":"Re: Join us as we celebrate Gartner Peer Insights Customers' Choice 2023 🥳 Enter to win swag","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385445#Comment_385445","dateInserted":"2023-07-14T22:46:13+00:00","insertUserID":151354,"insertUser":{"userID":151354,"name":"ValerieSD","url":"https:\/\/community.smartsheet.com\/profile\/ValerieSD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jMFXI6NkxPs!5OfW-X9-Zj0!VzIuv5dqAYE","dateLastActive":"2023-07-14T23:01:13+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\/49QXD1VDVH1A\/screenshot-2023-07-03-at-5-17-50-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-07-03 at 5.17.50 PM.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":[]},"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":2}],"tags":[{"tagID":458,"urlcode":"giveaway","name":"giveaway"}]},{"discussionID":106739,"type":"discussion","name":"Sheet Picker Update for Move\/Copy Row Automations is now generally available","excerpt":"Hi Community, We updated the sheet picker UI used to specify the destination sheet for move and copy row automated workflows. The new sheet picker UI is faster and more consistent with other areas of the product, like Search and Reports. Licensed users on all Commercial US and Commercial EU plans will have access to the…","snippet":"Hi Community, We updated the sheet picker UI used to specify the destination sheet for move and copy row automated workflows. The new sheet picker UI is faster and more consistent…","categoryID":335,"dateInserted":"2023-06-21T22:27:40+00:00","dateUpdated":"2023-07-14T16:31:12+00:00","dateLastComment":"2023-07-14T18:59:20+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-07-14T16:30:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":84306,"lastUserID":158244,"lastUser":{"userID":158244,"name":"Josh W","url":"https:\/\/community.smartsheet.com\/profile\/Josh%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-14T18:52:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":25,"countViews":468,"score":1,"hot":3376762920,"url":"https:\/\/community.smartsheet.com\/discussion\/106739\/sheet-picker-update-for-move-copy-row-automations-is-now-generally-available","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106739\/sheet-picker-update-for-move-copy-row-automations-is-now-generally-available","format":"Rich","lastPost":{"discussionID":106739,"commentID":385382,"name":"Re: Sheet Picker Update for Move\/Copy Row Automations is now generally available","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385382#Comment_385382","dateInserted":"2023-07-14T18:59:20+00:00","insertUserID":158244,"insertUser":{"userID":158244,"name":"Josh W","url":"https:\/\/community.smartsheet.com\/profile\/Josh%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-14T18:52:53+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3KFHB0GETVK5\/sheet-picker-after.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Sheet picker - after.jpg"},"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":[]},{"discussionID":107011,"type":"discussion","name":"Join the conversation + Help us use sponsorships as a force for good","excerpt":"Smartsheet and McLaren Racing are teaming up to showcase STEAM Co. on the tracks at the British Grand Prix. And you, our members can join the conversation and help shine a light on this deserving nonprofit that inspires children and ignites creativity in our schools, our work, and our lives with their resounding message to…","snippet":"Smartsheet and McLaren Racing are teaming up to showcase STEAM Co. on the tracks at the British Grand Prix. And you, our members can join the conversation and help shine a light…","categoryID":351,"dateInserted":"2023-06-28T13:18:39+00:00","dateUpdated":"2023-06-28T16:36:13+00:00","dateLastComment":"2023-07-13T14:19:44+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-07-14T18:38:45+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":145232,"lastUserID":36441,"lastUser":{"userID":36441,"name":"Deanna Vandermeer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Deanna%20Vandermeer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S6G9UVDETAVZ\/nODNJ5BK1MFSA.jpeg","dateLastActive":"2023-07-14T14:17:58+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":23,"countViews":454,"score":4,"hot":3377231303,"url":"https:\/\/community.smartsheet.com\/discussion\/107011\/join-the-conversation-help-us-use-sponsorships-as-a-force-for-good","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107011\/join-the-conversation-help-us-use-sponsorships-as-a-force-for-good","format":"Rich","tagIDs":[470],"lastPost":{"discussionID":107011,"commentID":385005,"name":"Re: Join the conversation + Help us use sponsorships as a force for good","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385005#Comment_385005","dateInserted":"2023-07-13T14:19:44+00:00","insertUserID":36441,"insertUser":{"userID":36441,"name":"Deanna Vandermeer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Deanna%20Vandermeer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S6G9UVDETAVZ\/nODNJ5BK1MFSA.jpeg","dateLastActive":"2023-07-14T14:17:58+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"},{"name":"Sponsor X","url":"https:\/\/community.smartsheet.com\/categories\/sponsor-x"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HDRC8X43F8N2\/steamco-badge-2.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"steamco-badge-2.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":351,"name":"Sponsor X","url":"https:\/\/community.smartsheet.com\/categories\/sponsor-x","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":4}],"tags":[{"tagID":470,"urlcode":"sponsor-x","name":"SponsorX"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&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":34,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…<\/p>\n<\/li>\n
Hi community! Excuse me if it sounds like a dumb question but I just can't find any hint that would help me to choose between these functions to get the fastest in execution and most efficient. Here's two formulas that gives the same results: =SUMIFS([ITEM qty]:[ITEM qty]; [COMPLETED]:[COMPLETED]; <>0;…<\/p>\n<\/li>\n
Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both insightful and creative. We're kicking off July with a new questions and another opportunity for you to earn badges and points while getting to know…<\/p>\n<\/li>\n
When the selected report view includes days (e.g. Time & Fees>Days, or Time & Fees>Amounts & Days), it seems logical to expect that the underlying data includes at least 1 column for days. Unfortunately this is not the case; currently, the underlying data has 4 different columns for hours (Scheduled, Incurred, Difference…<\/p>\n<\/li>\n
HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and subsequent actions, but both flows end with a notification step. The "Above R5000" = Yes" condition works perfectly but the "Above R5000 = No"…<\/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","expand":["all","-body"]},"discussions":[{"discussionID":107659,"type":"question","name":"How to make Parent helper column reflect values based on Children values with multiple conditions","excerpt":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…","snippet":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column…","categoryID":322,"dateInserted":"2023-07-17T01:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T03:11:33+00:00","insertUserID":157192,"insertUser":{"userID":157192,"name":"decrom","url":"https:\/\/community.smartsheet.com\/profile\/decrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:18:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":16,"score":null,"hot":3379122318,"url":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107659,"commentID":385499,"name":"Re: How to make Parent helper column reflect values based on Children values with multiple conditions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385499#Comment_385499","dateInserted":"2023-07-17T03:11:33+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+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":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8JA27C48KJIR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T02:55:22+00:00","dateAnswered":"2023-07-17T02:36:04+00:00","acceptedAnswers":[{"commentID":385496,"body":"
Hey @decrom<\/a> <\/p> Try this and see if it produces the expected result. Please be sure to test one 'In Process' with ZERO 'Untrained'. Was this what you expected?<\/p> =IF(COUNT(CHILDREN(Proficiency@row)) > 0, IF(COUNT(CHILDREN(Proficiency@row)) = COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\"), \"Untrained\", IF(AND(COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\") >= 1, COUNT(CHILDREN(Proficiency@row)) > COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\")), \"In Progress\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"In Process\") >= 1, \"In Process\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Trained\") >= 1, \"Trained\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Proficient\") >= 1, \"Proficient\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Preceptor\") >= 1, \"Preceptor\")))))))<\/p> Please let me know what we need to tweak<\/p> Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","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":[]},"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":107654,"type":"question","name":"Fonctions: FIND vs CONTAINS","excerpt":"Hi community! Excuse me if it sounds like a dumb question but I just can't find any hint that would help me to choose between these functions to get the fastest in execution and most efficient. Here's two formulas that gives the same results: =SUMIFS([ITEM qty]:[ITEM qty]; [COMPLETED]:[COMPLETED]; <>0;…","snippet":"Hi community! Excuse me if it sounds like a dumb question but I just can't find any hint that would help me to choose between these functions to get the fastest in execution and…","categoryID":322,"dateInserted":"2023-07-16T13:30:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T02:49:25+00:00","insertUserID":163534,"insertUser":{"userID":163534,"name":"Cbastien","title":"Construction worker","url":"https:\/\/community.smartsheet.com\/profile\/Cbastien","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-16T23:17:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3379076972,"url":"https:\/\/community.smartsheet.com\/discussion\/107654\/fonctions-find-vs-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107654\/fonctions-find-vs-contains","format":"Rich","lastPost":{"discussionID":107654,"commentID":385498,"name":"Re: Fonctions: FIND vs CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385498#Comment_385498","dateInserted":"2023-07-17T02:49:25+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+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,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-17T02:49:25+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":[]},"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":107188,"type":"question","name":"July Question of the Month 💭 Join the conversation and receive a badge!","excerpt":"Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both insightful and creative. We're kicking off July with a new questions and another opportunity for you to earn badges and points while getting to know…","snippet":"Hi everyone, Last month, more of you than ever before joined in on the Question of the Month, summing up your Smartsheet experience in one word only. Your answers were both…","categoryID":346,"dateInserted":"2023-07-03T18:32:48+00:00","dateUpdated":"2023-07-06T17:20:12+00:00","dateLastComment":"2023-07-17T01:40:14+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-07-14T18:38:45+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":158672,"lastUser":{"userID":158672,"name":"Rachel Martin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rachel%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/WBPQOPI4NUPG\/n0367C5WQO010.jpeg","dateLastActive":"2023-07-17T01:15:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":100,"countViews":955,"score":5,"hot":3378028682,"url":"https:\/\/community.smartsheet.com\/discussion\/107188\/july-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107188\/july-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[493],"lastPost":{"discussionID":107188,"commentID":385495,"name":"Re: July Question of the Month 💭 Join the conversation and receive a badge!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385495#Comment_385495","dateInserted":"2023-07-17T01:40:14+00:00","insertUserID":158672,"insertUser":{"userID":158672,"name":"Rachel Martin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Rachel%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/WBPQOPI4NUPG\/n0367C5WQO010.jpeg","dateLastActive":"2023-07-17T01:15:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/lh6.googleusercontent.com\/RRWg66zXQZMOazwkF0W3pdxUJKtK6zI7oz_lHB-w3I9YtULm0c8GmhjsxDEXSOaDnIfL7XH5h4u6pxgxB2_3KZRWTcyoc136y-I7KsPPccUxtmN7mH5WOC5IJ11I5quxC_gAqFhDq1HaAaNfudOEEdg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"RRWg66zXQZMOazwkF0W3pdxUJKtK6zI7oz_lHB-w3I9YtULm0c8GmhjsxDEXSOaDnIfL7XH5h4u6pxgxB2_3KZRWTcyoc136y-I7KsPPccUxtmN7mH5WOC5IJ11I5quxC_gAqFhDq1HaAaNfudOEEdg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-03T19:33:28+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":4}],"tags":[{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":107658,"type":"idea","name":"Resource Management: Days column in Underlying Data","excerpt":"When the selected report view includes days (e.g. Time & Fees>Days, or Time & Fees>Amounts & Days), it seems logical to expect that the underlying data includes at least 1 column for days. Unfortunately this is not the case; currently, the underlying data has 4 different columns for hours (Scheduled, Incurred, Difference…","snippet":"When the selected report view includes days (e.g. Time & Fees>Days, or Time & Fees>Amounts & Days), it seems logical to expect that the underlying data includes at least 1 column…","categoryID":349,"dateInserted":"2023-07-17T01:03:15+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T01:03:15+00:00","insertUserID":161657,"insertUser":{"userID":161657,"name":"Nicole DLS","url":"https:\/\/community.smartsheet.com\/profile\/Nicole%20DLS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:36:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161657,"lastUser":{"userID":161657,"name":"Nicole DLS","url":"https:\/\/community.smartsheet.com\/profile\/Nicole%20DLS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:36:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":14,"score":1,"hot":1689556095,"url":"https:\/\/community.smartsheet.com\/discussion\/107658\/resource-management-days-column-in-underlying-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107658\/resource-management-days-column-in-underlying-data","format":"Rich","tagIDs":[265,363,468],"lastPost":{"discussionID":107658,"name":"Resource Management: Days column in Underlying Data","url":"https:\/\/community.smartsheet.com\/discussion\/107658\/resource-management-days-column-in-underlying-data","dateInserted":"2023-07-17T01:03:15+00:00","insertUserID":161657,"insertUser":{"userID":161657,"name":"Nicole DLS","url":"https:\/\/community.smartsheet.com\/profile\/Nicole%20DLS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:36:46+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":1}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]},{"discussionID":107655,"type":"question","name":"Approval Workflow not sending notification","excerpt":"HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and subsequent actions, but both flows end with a notification step. The \"Above R5000\" = Yes\" condition works perfectly but the \"Above R5000 = No\"…","snippet":"HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and…","categoryID":321,"dateInserted":"2023-07-16T19:27:05+00:00","dateUpdated":"2023-07-16T19:27:26+00:00","dateLastComment":"2023-07-17T00:37:48+00:00","insertUserID":163536,"insertUser":{"userID":163536,"name":"Marce Holzhauzen","url":"https:\/\/community.smartsheet.com\/profile\/Marce%20Holzhauzen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nmtVP-N3FLQ!xJjUcc9t7dY!1vX0UcqCJb4","dateLastActive":"2023-07-16T20:10:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163536,"lastUserID":162395,"lastUser":{"userID":162395,"name":"AravindGP","title":"Principal Consultant at atturra","url":"https:\/\/community.smartsheet.com\/profile\/AravindGP","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gj8p3_p0u-o!2qNpfwZ83HI!-yrLbvX61mQ","dateLastActive":"2023-07-17T00:32:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3379090493,"url":"https:\/\/community.smartsheet.com\/discussion\/107655\/approval-workflow-not-sending-notification","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107655\/approval-workflow-not-sending-notification","format":"Rich","lastPost":{"discussionID":107655,"commentID":385494,"name":"Re: Approval Workflow not sending notification","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385494#Comment_385494","dateInserted":"2023-07-17T00:37:48+00:00","insertUserID":162395,"insertUser":{"userID":162395,"name":"AravindGP","title":"Principal Consultant at atturra","url":"https:\/\/community.smartsheet.com\/profile\/AravindGP","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gj8p3_p0u-o!2qNpfwZ83HI!-yrLbvX61mQ","dateLastActive":"2023-07-17T00:32:16+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/U532QOEYOV44\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-17T00:37:48+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":[]},"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&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":" I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…<\/p>\n<\/li>\n I'm trying to share a document once it's created, and some people may get lost if they go to the smartsheet to view. I'm trying to figure out a way to automate to send the actual document (not a link) sent to my email? that way i can create an automation from there that will send to everyone who needs it. My other thought…<\/p>\n<\/li>\n HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and subsequent actions, but both flows end with a notification step. The "Above R5000" = Yes" condition works perfectly but the "Above R5000 = No"…<\/p>\n<\/li>\n Hi community! Excuse me if it sounds like a dumb question but I just can't find any hint that would help me to choose between these functions to get the fastest in execution and most efficient. Here's two formulas that gives the same results: =SUMIFS([ITEM qty]:[ITEM qty]; [COMPLETED]:[COMPLETED]; <>0;…<\/p>\n<\/li>\n Hi, I want my Live Status column to change as the stage progress, For ex; if my Status LO is complete my live status column should get status change to "LO Complete" and when Status LO Lock (LDS R1) changes to "Complete" the live status should change to " LO Lock(LDS R1) Complete" and so on<\/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","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":107659,"type":"question","name":"How to make Parent helper column reflect values based on Children values with multiple conditions","excerpt":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…","snippet":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column…","categoryID":322,"dateInserted":"2023-07-17T01:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T03:11:33+00:00","insertUserID":157192,"insertUser":{"userID":157192,"name":"decrom","url":"https:\/\/community.smartsheet.com\/profile\/decrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:18:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":16,"score":null,"hot":3379122318,"url":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107659,"commentID":385499,"name":"Re: How to make Parent helper column reflect values based on Children values with multiple conditions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385499#Comment_385499","dateInserted":"2023-07-17T03:11:33+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T03:04:53+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":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8JA27C48KJIR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T02:55:22+00:00","dateAnswered":"2023-07-17T02:36:04+00:00","acceptedAnswers":[{"commentID":385496,"body":"Newest Questions<\/h2> <\/div>\n
\n
Explore. Ask. Answer
Discussion List
Categories
Popular Tags
This Week's Leaders
This Month's Leaders