Areas to explore
\n
\n Announcements<\/h2> <\/div>\n
Announcements<\/h2> <\/div>\n \n- \nJuly Question of the Month 💭 Join the conversation and receive a badge!<\/a>\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
- \nLimit increase: 500,000 inbound cell links<\/a>\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
- \nJoin us as we celebrate Gartner Peer Insights Customers' Choice 2023 🥳 Enter to win swag<\/a>\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
- \nSheet Picker Update for Move\/Copy Row Automations is now generally available<\/a>\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
- \nJoin the conversation + Help us use sponsorships as a force for good<\/a>\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":958,"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":276,"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":185,"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":491,"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":457,"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":"
\n \n Recent Discussions<\/h2> <\/div>\n \n- \nAdd pictures inside a cells which look like a form - Workapps<\/a>\n
Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…<\/p>\n<\/li>\n
- \nConvert into column formula w\/o syntax error<\/a>\n
Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n
- \nduplicates mark 1 with tick box<\/a>\n
Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:"123", "234", "456" Let say "123"is repeated 5 times along the column, "234"- 4 times, "345"- 7 times. Is it possible to marke with a tick…<\/p>\n<\/li>\n
- \nCan Smartsheets talk to each other?<\/a>\n
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…<\/p>\n<\/li>\n
- \nDate with Time uploading in Data Shuttle comes only with Date<\/a>\n
Hi Everyone, I'm uploading Input excel having column value "6\/1\/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P<\/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":107613,"type":"question","name":"Add pictures inside a cells which look like a form - Workapps","excerpt":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…","snippet":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt…","categoryID":322,"dateInserted":"2023-07-14T10:56:40+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151421,"lastUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3378913687,"url":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","format":"Rich","lastPost":{"discussionID":107613,"commentID":385504,"name":"Re: Add pictures inside a cells which look like a form - Workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385504#Comment_385504","dateInserted":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+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\/ZA10DMWH9B2G\/image-2023-07-14-11-46-59.jpeg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Image 2023-07-14 11-46-59.jpeg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-15T08:51:38+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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":76845,"type":"question","name":"duplicates mark 1 with tick box","excerpt":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:\"123\", \"234\", \"456\" Let say \"123\"is repeated 5 times along the column, \"234\"- 4 times, \"345\"- 7 times. Is it possible to marke with a tick…","snippet":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3…","categoryID":321,"dateInserted":"2021-03-03T11:36:15+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:15:47+00:00","insertUserID":131273,"insertUser":{"userID":131273,"name":"Christine Menke","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Menke","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!wxtct5RkPno!3WtdPxB0jLw!Ul_V8Bw57zI","dateLastActive":"2023-03-22T12:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":144,"score":null,"hot":3304350722,"url":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","format":"Rich","lastPost":{"discussionID":76845,"commentID":385503,"name":"Re: duplicates mark 1 with tick box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385503#Comment_385503","dateInserted":"2023-07-17T07:15:47+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":"2021-03-03T12:20:42+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":[]},{"discussionID":104437,"type":"question","name":"Can Smartsheets talk to each other?","excerpt":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…","snippet":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who…","categoryID":322,"dateInserted":"2023-04-25T15:23:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T06:25:39+00:00","insertUserID":160858,"insertUser":{"userID":160858,"name":"Aimee Pickett","title":"Administrator","url":"https:\/\/community.smartsheet.com\/profile\/Aimee%20Pickett","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3zkrP6PigLo!24MovwvQ43o!dGYzfEhPVna","dateLastActive":"2023-05-03T13:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163539,"lastUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":118,"score":null,"hot":3372014326,"url":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","format":"Rich","tagIDs":[245,265,334,440,442],"lastPost":{"discussionID":104437,"commentID":385502,"name":"Re: Can Smartsheets talk to each other?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385502#Comment_385502","dateInserted":"2023-07-17T06:25:39+00:00","insertUserID":163539,"insertUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+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-04-25T15:56:09+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":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":95065,"type":"question","name":"Date with Time uploading in Data Shuttle comes only with Date","excerpt":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P","snippet":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which…","categoryID":343,"dateInserted":"2022-09-06T04:45:49+00:00","dateUpdated":"2022-09-19T13:55:39+00:00","dateLastComment":"2023-07-17T05:45:57+00:00","insertUserID":140679,"insertUser":{"userID":140679,"name":"Sandhiya07","url":"https:\/\/community.smartsheet.com\/profile\/Sandhiya07","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-15T05:36:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"lastUserID":160587,"lastUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":187,"score":null,"hot":3352018306,"url":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":95065,"commentID":385501,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385501#Comment_385501","dateInserted":"2023-07-17T05:45:57+00:00","insertUserID":160587,"insertUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-19T12:13:48+00:00","dateAnswered":"2022-09-09T10:19:47+00:00","acceptedAnswers":[{"commentID":342967,"body":"
Hi @Sandhiya07<\/a> <\/p>Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p>
If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p>Let me know if that works for you!<\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"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":"
\n \n Newest Questions<\/h2> <\/div>\n \n- \nConvert into column formula w\/o syntax error<\/a>\n
Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n
- \nHow to make Parent helper column reflect values based on Children values with multiple conditions<\/a>\n
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
- \nIs there any way when generating a document to have it (not a link) sent to an email address?<\/a>\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
- \nApproval Workflow not sending notification<\/a>\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
- \nFonctions: FIND vs CONTAINS<\/a>\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<\/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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":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":24,"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":"
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
0;…","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":20,"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","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-17T02:49:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":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…","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-17T06:27:14+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-17T06:27:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":34,"score":2,"hot":1689556395,"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","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"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\"…","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":14,"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","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":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
Categories
Popular Tags
- Formulas10,467
- Project Management4,337
- Sheets3,655
- Reports2,549
- 形式2,321
- functionality2,112
- Automations1,758
- IT & Operations1,744
- 支持1,522
- Cell linking1,509
- Enhancement Request1488年
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,213
- Conditional Formatting1,184
- Dashboards1,167
- Construction1,085
- API and Developers884
- Sharing and Collaboration876
- Manufacturing862
- Update Requests802
- Workflows in Smartsheet781
- Gantt View775
- Product Development769
- Attachments763
This Week's Leaders
This Month's Leaders
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":958,"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":276,"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":185,"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":491,"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":457,"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":"
\n
\n Recent Discussions<\/h2> <\/div>\n
Recent Discussions<\/h2> <\/div>\n \n- \nAdd pictures inside a cells which look like a form - Workapps<\/a>\n
Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…<\/p>\n<\/li>\n
- \nConvert into column formula w\/o syntax error<\/a>\n
Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n
- \nduplicates mark 1 with tick box<\/a>\n
Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:"123", "234", "456" Let say "123"is repeated 5 times along the column, "234"- 4 times, "345"- 7 times. Is it possible to marke with a tick…<\/p>\n<\/li>\n
- \nCan Smartsheets talk to each other?<\/a>\n
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…<\/p>\n<\/li>\n
- \nDate with Time uploading in Data Shuttle comes only with Date<\/a>\n
Hi Everyone, I'm uploading Input excel having column value "6\/1\/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P<\/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":107613,"type":"question","name":"Add pictures inside a cells which look like a form - Workapps","excerpt":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…","snippet":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt…","categoryID":322,"dateInserted":"2023-07-14T10:56:40+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151421,"lastUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3378913687,"url":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","format":"Rich","lastPost":{"discussionID":107613,"commentID":385504,"name":"Re: Add pictures inside a cells which look like a form - Workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385504#Comment_385504","dateInserted":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+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\/ZA10DMWH9B2G\/image-2023-07-14-11-46-59.jpeg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Image 2023-07-14 11-46-59.jpeg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-15T08:51:38+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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":76845,"type":"question","name":"duplicates mark 1 with tick box","excerpt":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:\"123\", \"234\", \"456\" Let say \"123\"is repeated 5 times along the column, \"234\"- 4 times, \"345\"- 7 times. Is it possible to marke with a tick…","snippet":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3…","categoryID":321,"dateInserted":"2021-03-03T11:36:15+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:15:47+00:00","insertUserID":131273,"insertUser":{"userID":131273,"name":"Christine Menke","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Menke","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!wxtct5RkPno!3WtdPxB0jLw!Ul_V8Bw57zI","dateLastActive":"2023-03-22T12:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":144,"score":null,"hot":3304350722,"url":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","format":"Rich","lastPost":{"discussionID":76845,"commentID":385503,"name":"Re: duplicates mark 1 with tick box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385503#Comment_385503","dateInserted":"2023-07-17T07:15:47+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":"2021-03-03T12:20:42+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":[]},{"discussionID":104437,"type":"question","name":"Can Smartsheets talk to each other?","excerpt":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…","snippet":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who…","categoryID":322,"dateInserted":"2023-04-25T15:23:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T06:25:39+00:00","insertUserID":160858,"insertUser":{"userID":160858,"name":"Aimee Pickett","title":"Administrator","url":"https:\/\/community.smartsheet.com\/profile\/Aimee%20Pickett","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3zkrP6PigLo!24MovwvQ43o!dGYzfEhPVna","dateLastActive":"2023-05-03T13:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163539,"lastUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":118,"score":null,"hot":3372014326,"url":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","format":"Rich","tagIDs":[245,265,334,440,442],"lastPost":{"discussionID":104437,"commentID":385502,"name":"Re: Can Smartsheets talk to each other?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385502#Comment_385502","dateInserted":"2023-07-17T06:25:39+00:00","insertUserID":163539,"insertUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+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-04-25T15:56:09+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":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":95065,"type":"question","name":"Date with Time uploading in Data Shuttle comes only with Date","excerpt":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P","snippet":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which…","categoryID":343,"dateInserted":"2022-09-06T04:45:49+00:00","dateUpdated":"2022-09-19T13:55:39+00:00","dateLastComment":"2023-07-17T05:45:57+00:00","insertUserID":140679,"insertUser":{"userID":140679,"name":"Sandhiya07","url":"https:\/\/community.smartsheet.com\/profile\/Sandhiya07","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-15T05:36:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"lastUserID":160587,"lastUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":187,"score":null,"hot":3352018306,"url":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":95065,"commentID":385501,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385501#Comment_385501","dateInserted":"2023-07-17T05:45:57+00:00","insertUserID":160587,"insertUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-19T12:13:48+00:00","dateAnswered":"2022-09-09T10:19:47+00:00","acceptedAnswers":[{"commentID":342967,"body":"
Hi @Sandhiya07<\/a> <\/p>Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p>
If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p>Let me know if that works for you!<\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"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":"
\n \n Newest Questions<\/h2> <\/div>\n \n- \nConvert into column formula w\/o syntax error<\/a>\n
Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n
- \nHow to make Parent helper column reflect values based on Children values with multiple conditions<\/a>\n
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
- \nIs there any way when generating a document to have it (not a link) sent to an email address?<\/a>\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
- \nApproval Workflow not sending notification<\/a>\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
- \nFonctions: FIND vs CONTAINS<\/a>\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<\/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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":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":24,"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":"
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
0;…","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":20,"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","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-17T02:49:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":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…","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-17T06:27:14+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-17T06:27:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":34,"score":2,"hot":1689556395,"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","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"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\"…","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":14,"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","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":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
Categories
Popular Tags
- Formulas10,467
- Project Management4,337
- Sheets3,655
- Reports2,549
- 形式2,321
- functionality2,112
- Automations1,758
- IT & Operations1,744
- 支持1,522
- Cell linking1,509
- Enhancement Request1488年
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,213
- Conditional Formatting1,184
- Dashboards1,167
- Construction1,085
- API and Developers884
- Sharing and Collaboration876
- Manufacturing862
- Update Requests802
- Workflows in Smartsheet781
- Gantt View775
- Product Development769
- Attachments763
This Week's Leaders
This Month's Leaders
Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…<\/p>\n<\/li>\n
Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n
Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:"123", "234", "456" Let say "123"is repeated 5 times along the column, "234"- 4 times, "345"- 7 times. Is it possible to marke with a tick…<\/p>\n<\/li>\n
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…<\/p>\n<\/li>\n
Hi Everyone, I'm uploading Input excel having column value "6\/1\/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P<\/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":107613,"type":"question","name":"Add pictures inside a cells which look like a form - Workapps","excerpt":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt look likes a grid view but like card and we can add pictures inside a cells. You can see that in the picture that I add. If anydbody have a…","snippet":"Hi everyone, I have just discover a thing in the Workapps. I made the same as all the other date : open my sheet (grid view) on my workapps. However, this time the sheet does'nt…","categoryID":322,"dateInserted":"2023-07-14T10:56:40+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151421,"lastUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3378913687,"url":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107613\/add-pictures-inside-a-cells-which-look-like-a-form-workapps","format":"Rich","lastPost":{"discussionID":107613,"commentID":385504,"name":"Re: Add pictures inside a cells which look like a form - Workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385504#Comment_385504","dateInserted":"2023-07-17T07:51:27+00:00","insertUserID":151421,"insertUser":{"userID":151421,"name":"lea.s6","url":"https:\/\/community.smartsheet.com\/profile\/lea.s6","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!G69Wn8Gn53s!xLDXMWmx7Oc!BP_1d2Auq2F","dateLastActive":"2023-07-17T07:17:37+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\/ZA10DMWH9B2G\/image-2023-07-14-11-46-59.jpeg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Image 2023-07-14 11-46-59.jpeg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-15T08:51:38+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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":76845,"type":"question","name":"duplicates mark 1 with tick box","excerpt":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3 numbers:\"123\", \"234\", \"456\" Let say \"123\"is repeated 5 times along the column, \"234\"- 4 times, \"345\"- 7 times. Is it possible to marke with a tick…","snippet":"Hi Experts, I have a list in column with numbers that have different number of duplicates and i want to highlight only one (1st) cell that has duplicates. For example, these 3…","categoryID":321,"dateInserted":"2021-03-03T11:36:15+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:15:47+00:00","insertUserID":131273,"insertUser":{"userID":131273,"name":"Christine Menke","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Menke","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!wxtct5RkPno!3WtdPxB0jLw!Ul_V8Bw57zI","dateLastActive":"2023-03-22T12:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":144,"score":null,"hot":3304350722,"url":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76845\/duplicates-mark-1-with-tick-box","format":"Rich","lastPost":{"discussionID":76845,"commentID":385503,"name":"Re: duplicates mark 1 with tick box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385503#Comment_385503","dateInserted":"2023-07-17T07:15:47+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":"2021-03-03T12:20:42+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":[]},{"discussionID":104437,"type":"question","name":"Can Smartsheets talk to each other?","excerpt":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…","snippet":"I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who…","categoryID":322,"dateInserted":"2023-04-25T15:23:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T06:25:39+00:00","insertUserID":160858,"insertUser":{"userID":160858,"name":"Aimee Pickett","title":"Administrator","url":"https:\/\/community.smartsheet.com\/profile\/Aimee%20Pickett","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3zkrP6PigLo!24MovwvQ43o!dGYzfEhPVna","dateLastActive":"2023-05-03T13:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163539,"lastUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":118,"score":null,"hot":3372014326,"url":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104437\/can-smartsheets-talk-to-each-other","format":"Rich","tagIDs":[245,265,334,440,442],"lastPost":{"discussionID":104437,"commentID":385502,"name":"Re: Can Smartsheets talk to each other?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385502#Comment_385502","dateInserted":"2023-07-17T06:25:39+00:00","insertUserID":163539,"insertUser":{"userID":163539,"name":"upgradeyard","title":"dafa","url":"https:\/\/community.smartsheet.com\/profile\/upgradeyard","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfVV8UF4BSHPC-BGfZ_97OcBhc5Xq3tPJoCki7l3kaa=s96-c","dateLastActive":"2023-07-17T06:21:18+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-04-25T15:56:09+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":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":95065,"type":"question","name":"Date with Time uploading in Data Shuttle comes only with Date","excerpt":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P","snippet":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which…","categoryID":343,"dateInserted":"2022-09-06T04:45:49+00:00","dateUpdated":"2022-09-19T13:55:39+00:00","dateLastComment":"2023-07-17T05:45:57+00:00","insertUserID":140679,"insertUser":{"userID":140679,"name":"Sandhiya07","url":"https:\/\/community.smartsheet.com\/profile\/Sandhiya07","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-15T05:36:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"lastUserID":160587,"lastUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":187,"score":null,"hot":3352018306,"url":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":95065,"commentID":385501,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385501#Comment_385501","dateInserted":"2023-07-17T05:45:57+00:00","insertUserID":160587,"insertUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-19T12:13:48+00:00","dateAnswered":"2022-09-09T10:19:47+00:00","acceptedAnswers":[{"commentID":342967,"body":"
Hi @Sandhiya07<\/a> <\/p> Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p> If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p> Let me know if that works for you!<\/p> Cheers,<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"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":" Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor<\/p>\n<\/li>\n 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<\/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":107660,"type":"question","name":"Convert into column formula w\/o syntax error","excerpt":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor","snippet":"Hello, Could you help me please ? I try to convert following formula into column formula w\/o syntax error , unfortunately without success. Do you know by heart how I can do it ?…","categoryID":321,"dateInserted":"2023-07-17T07:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157604,"lastUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","format":"Rich","lastPost":{"discussionID":107660,"name":"Convert into column formula w\/o syntax error","url":"https:\/\/community.smartsheet.com\/discussion\/107660\/convert-into-column-formula-w-o-syntax-error","dateInserted":"2023-07-17T07:18:37+00:00","insertUserID":157604,"insertUser":{"userID":157604,"name":"Tibor","url":"https:\/\/community.smartsheet.com\/profile\/Tibor","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7lMu-xZ-U_s!m8dvH8Ix5TM!Yu3yWRgwrW2","dateLastActive":"2023-07-17T07:29:35+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":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":[]},"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":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":24,"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":"\n
\n
Newest Questions<\/h2> <\/div>\n
\n
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
0;…","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":20,"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","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-17T02:49:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":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…","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-17T06:27:14+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-17T06:27:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":34,"score":2,"hot":1689556395,"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","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"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\"…","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":14,"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","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":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
Categories
Popular Tags
This Week's Leaders
This Month's Leaders
