Areas to explore
\n
\n Announcements<\/h2> <\/div>\n
Announcements<\/h2> <\/div>\n \n- \n[RECAP] ENGAGE 2023: Potential Unlocked<\/a>\n
Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just a few highlights from the week: Community Champions & Overachievers took the stage: These program members not only came together during the…<\/p>\n<\/li>\n
- \nSeptember Question of the Month 💭 Join the conversation and receive a badge<\/a>\n
Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…<\/p>\n<\/li>\n
- \nNew! TIME function for formulas<\/a>\n
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…<\/p>\n<\/li>\n
- \nDon't miss our ENGAGE Women in IT Luncheon event!<\/a>\n
We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE while fostering an environment of diversity, equity, and inclusivity within the tech industry. Event details: Tuesday, Sept. 20 Time: 11:30 a.m.…<\/p>\n<\/li>\n
- \nSmartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!<\/a>\n
Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out your peers’ amazing submissions and show support to your favorites by using the Vote up and Awesome icon reactions, and you’ll be entered into a…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Announcements","componentName":"DiscussionListModule","componentProps":{"apiParams":{"pinned":true,"limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","sort":"-dateLastComment","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110900,"type":"discussion","name":"[RECAP] ENGAGE 2023: Potential Unlocked","excerpt":"Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just a few highlights from the week: Community Champions & Overachievers took the stage: These program members not only came together during the…","snippet":"Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just…","categoryID":336,"dateInserted":"2023-09-28T01:56:27+00:00","dateUpdated":"2023-09-28T15:45:07+00:00","dateLastComment":"2023-09-28T14:52:57+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-09-28T15:15:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":126614,"lastUserID":166730,"lastUser":{"userID":166730,"name":"Monicacraven","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Monicacraven","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p-ldafb73jo!nDlQn-Shgro!geYRKbS4OXN","dateLastActive":"2023-09-28T14:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":4,"countViews":74,"score":3,"hot":3391785394,"url":"https:\/\/community.smartsheet.com\/discussion\/110900\/recap-engage-2023-potential-unlocked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110900\/recap-engage-2023-potential-unlocked","format":"Rich","tagIDs":[355],"lastPost":{"discussionID":110900,"commentID":397442,"name":"Re: [RECAP] ENGAGE 2023: Potential Unlocked","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397442#Comment_397442","dateInserted":"2023-09-28T14:52:57+00:00","insertUserID":166730,"insertUser":{"userID":166730,"name":"Monicacraven","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Monicacraven","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p-ldafb73jo!nDlQn-Shgro!geYRKbS4OXN","dateLastActive":"2023-09-28T14:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1WW8H4B1PDBC\/pxl-20230920-171712946-7e2.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PXL_20230920_171712946~2.jpg"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":336,"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events","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":3}],"tags":[{"tagID":355,"urlcode":"engage","name":"ENGAGE"}]},{"discussionID":109746,"type":"discussion","name":"September Question of the Month 💭 Join the conversation and receive a badge","excerpt":"Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…","snippet":"Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own…","categoryID":346,"dateInserted":"2023-08-31T22:25:46+00:00","dateUpdated":"2023-09-25T08:09:47+00:00","dateLastComment":"2023-09-28T13:25:01+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-09-28T15:15:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":167633,"lastUser":{"userID":167633,"name":"RileyWinzer","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/RileyWinzer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":113,"countViews":1353,"score":1,"hot":3389496347,"url":"https:\/\/community.smartsheet.com\/discussion\/109746\/september-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109746\/september-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[324,493],"lastPost":{"discussionID":109746,"commentID":397416,"name":"Re: September Question of the Month 💭 Join the conversation and receive a badge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397416#Comment_397416","dateInserted":"2023-09-28T13:25:01+00:00","insertUserID":167633,"insertUser":{"userID":167633,"name":"RileyWinzer","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/RileyWinzer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:47:42+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\/J6FYD7YWV5F3\/community-question-of-the-months-badges-09.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Community Question of the Months - Badges-09.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":["discussion","poll","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":110711,"type":"discussion","name":"New! TIME function for formulas","excerpt":"Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…","snippet":"Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format…","categoryID":335,"dateInserted":"2023-09-25T12:44:02+00:00","dateUpdated":"2023-09-25T21:13:56+00:00","dateLastComment":"2023-09-27T22:53:29+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-09-28T16:36:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-09-27T22:51:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":7,"countViews":157,"score":10,"hot":3391508251,"url":"https:\/\/community.smartsheet.com\/discussion\/110711\/new-time-function-for-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110711\/new-time-function-for-formulas","format":"Rich","tagIDs":[254,499],"lastPost":{"discussionID":110711,"commentID":397343,"name":"Re: New! TIME function for formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397343#Comment_397343","dateInserted":"2023-09-27T22:53:29+00:00","insertUserID":11072,"insertUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-09-27T22:51:42+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\/SDBJSXJ32A5A\/time.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"TIME.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":2},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":8}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":499,"urlcode":"time-calculation","name":"Time Calculation"}]},{"discussionID":110170,"type":"discussion","name":"Don't miss our ENGAGE Women in IT Luncheon event!","excerpt":"We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE while fostering an environment of diversity, equity, and inclusivity within the tech industry. Event details: Tuesday, Sept. 20 Time: 11:30 a.m.…","snippet":"We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE…","categoryID":336,"dateInserted":"2023-09-12T20:25:48+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T22:34:10+00:00","insertUserID":121357,"insertUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":121357,"lastUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":13,"countViews":214,"score":4,"hot":3390413398,"url":"https:\/\/community.smartsheet.com\/discussion\/110170\/dont-miss-our-engage-women-in-it-luncheon-event","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110170\/dont-miss-our-engage-women-in-it-luncheon-event","format":"Rich","tagIDs":[355,593],"lastPost":{"discussionID":110170,"commentID":397342,"name":"Re: Don't miss our ENGAGE Women in IT Luncheon event!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397342#Comment_397342","dateInserted":"2023-09-27T22:34:10+00:00","insertUserID":121357,"insertUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M24UCRUCUVJG\/engage2023-women-in-it-badge.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ENGAGE2023-women-in-it-badge.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":336,"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events","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":355,"urlcode":"engage","name":"ENGAGE"},{"tagID":593,"urlcode":"women-in-tech","name":"Women in Tech"}]},{"discussionID":109969,"type":"discussion","name":"Smartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!","excerpt":"Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out your peers’ amazing submissions and show support to your favorites by using the Vote up and Awesome icon reactions, and you’ll be entered into a…","snippet":"Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out…","categoryID":2,"dateInserted":"2023-09-07T15:43:14+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T14:37:31+00:00","insertUserID":161936,"insertUser":{"userID":161936,"name":"Rebeca S.","title":"Community Engagement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Rebeca%20S.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqEp__PbH_o!bWcqW9OZSjo!5kR2l6b41gd","dateLastActive":"2023-09-28T16:39:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":149066,"lastUser":{"userID":149066,"name":"Cassi","url":"https:\/\/community.smartsheet.com\/profile\/Cassi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/27DD21PQ9H0Z\/nOQFD6KIZHJKL.jpg","dateLastActive":"2023-09-27T20:29:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":6,"countViews":211,"score":2,"hot":3389931045,"url":"https:\/\/community.smartsheet.com\/discussion\/109969\/smartsheet-travel-diaries-bonus-giveaway-win-a-travel-kit","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109969\/smartsheet-travel-diaries-bonus-giveaway-win-a-travel-kit","format":"Rich","tagIDs":[355,458],"lastPost":{"discussionID":109969,"commentID":397237,"name":"Re: Smartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397237#Comment_397237","dateInserted":"2023-09-27T14:37:31+00:00","insertUserID":149066,"insertUser":{"userID":149066,"name":"Cassi","url":"https:\/\/community.smartsheet.com\/profile\/Cassi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/27DD21PQ9H0Z\/nOQFD6KIZHJKL.jpg","dateLastActive":"2023-09-27T20:29:39+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":"General Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcement"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KU5WW077B5ZC\/engage-2023-communityhomepage-smartraveldiaries-badge-v1-icon.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ENGAGE 2023 Smartsheet Travel Diaries Badge showing a balloon and clouds"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":2,"name":"General Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcement","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":2}],"tags":[{"tagID":355,"urlcode":"engage","name":"ENGAGE"},{"tagID":458,"urlcode":"giveaway","name":"giveaway"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&pinned=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":24,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n Recent Discussions<\/h2> <\/div>\n \n- \nCan the Duration column type be converted to a column formula?<\/a>\n
I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:<\/p>\n<\/li>\n
- \n3 week look ahead including past due tasks<\/a>\n
I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…<\/p>\n<\/li>\n
- \nIssue when values from form are not added into the sheet<\/a>\n
I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.<\/p>\n<\/li>\n
- \nBilling Dashboard Help - Rows of Data shown on the Dashboard<\/a>\n
I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…<\/p>\n<\/li>\n
- \nHow to show multiple projects by phase and date rolled up in one dashboard?<\/a>\n
Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":110886,"type":"question","name":"Can the Duration column type be converted to a column formula?","excerpt":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","snippet":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","categoryID":322,"dateInserted":"2023-09-27T20:12:48+00:00","dateUpdated":"2023-09-27T22:20:08+00:00","dateLastComment":"2023-09-28T16:40:11+00:00","insertUserID":154243,"insertUser":{"userID":154243,"name":"hoodm","url":"https:\/\/community.smartsheet.com\/profile\/hoodm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T20:09:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391765379,"url":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","format":"Rich","lastPost":{"discussionID":110886,"commentID":397463,"name":"Re: Can the Duration column type be converted to a column formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397463#Comment_397463","dateInserted":"2023-09-28T16:40:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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\/NZLZTVZ6GGAY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:40:11+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":110884,"type":"question","name":"3 week look ahead including past due tasks","excerpt":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…","snippet":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start…","categoryID":321,"dateInserted":"2023-09-27T19:44:22+00:00","dateUpdated":"2023-09-27T19:47:05+00:00","dateLastComment":"2023-09-28T16:39:00+00:00","insertUserID":146897,"insertUser":{"userID":146897,"name":"MGreenPKWY","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MGreenPKWY","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":146897,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391763602,"url":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","format":"Rich","lastPost":{"discussionID":110884,"commentID":397462,"name":"Re: 3 week look ahead including past due tasks","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397462#Comment_397462","dateInserted":"2023-09-28T16:39:00+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EA2HP5NRXFJ0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:39:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":110883,"type":"question","name":"Issue when values from form are not added into the sheet","excerpt":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.","snippet":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the…","categoryID":322,"dateInserted":"2023-09-27T19:31:49+00:00","dateUpdated":"2023-09-27T22:19:31+00:00","dateLastComment":"2023-09-28T16:38:16+00:00","insertUserID":166371,"insertUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3391762805,"url":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","format":"Rich","lastPost":{"discussionID":110883,"commentID":397461,"name":"Re: Issue when values from form are not added into the sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397461#Comment_397461","dateInserted":"2023-09-28T16:38:16+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:38:16+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":110882,"type":"question","name":"Billing Dashboard Help - Rows of Data shown on the Dashboard","excerpt":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…","snippet":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure…","categoryID":322,"dateInserted":"2023-09-27T19:23:11+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:37:45+00:00","insertUserID":165295,"insertUser":{"userID":165295,"name":"cmc484","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/cmc484","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T19:20:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":8,"score":null,"hot":3391762256,"url":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","format":"Rich","lastPost":{"discussionID":110882,"commentID":397460,"name":"Re: Billing Dashboard Help - Rows of Data shown on the Dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397460#Comment_397460","dateInserted":"2023-09-28T16:37:45+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:37:45+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":110879,"type":"question","name":"How to show multiple projects by phase and date rolled up in one dashboard?","excerpt":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","snippet":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","categoryID":321,"dateInserted":"2023-09-27T17:43:26+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:34:52+00:00","insertUserID":167577,"insertUser":{"userID":167577,"name":"againes","url":"https:\/\/community.smartsheet.com\/profile\/againes","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKwXIGqAqKXl1d9FO5qkd3C9mV7IlhC8Yo2lULbyj5o=s96-c","dateLastActive":"2023-09-28T16:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3391756098,"url":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","format":"Rich","lastPost":{"discussionID":110879,"commentID":397459,"name":"Re: How to show multiple projects by phase and date rolled up in one dashboard?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397459#Comment_397459","dateInserted":"2023-09-28T16:34:52+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:34:52+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n Newest Questions<\/h2> <\/div>\n \n- \nForms<\/a>\n
When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…<\/p>\n<\/li>\n
- \nExtract text from a file string<\/a>\n
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…<\/p>\n<\/li>\n
- \nCount Per Specified Criteria and Date Range<\/a>\n
I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…<\/p>\n<\/li>\n
- \nFinance Tracking and Executive Reporting<\/a>\n
Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…<\/p>\n<\/li>\n
- \nI am trying to convert a formula to a column formula and keep getting the same error. Why?<\/a>\n
The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is "The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information." The column type…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110936,"type":"question","name":"Forms","excerpt":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…","snippet":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know…","categoryID":321,"dateInserted":"2023-09-28T16:26:24+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166642,"lastUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","format":"Rich","lastPost":{"discussionID":110936,"name":"Forms","url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","dateInserted":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+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":110935,"type":"question","name":"Extract text from a file string","excerpt":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…","snippet":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse…","categoryID":322,"dateInserted":"2023-09-28T16:08:07+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159135,"lastUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110935,"name":"Extract text from a file string","url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","dateInserted":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110934,"type":"question","name":"Count Per Specified Criteria and Date Range","excerpt":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…","snippet":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality…","categoryID":322,"dateInserted":"2023-09-28T16:05:58+00:00","dateUpdated":"2023-09-28T16:09:37+00:00","dateLastComment":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":167648,"lastUserID":167648,"lastUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":5,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","format":"Rich","lastPost":{"discussionID":110934,"name":"Count Per Specified Criteria and Date Range","url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","dateInserted":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/45Y1WDBJR58H\/data-quality-notes-gc.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data Quality Notes - GC.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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":110933,"type":"question","name":"Finance Tracking and Executive Reporting","excerpt":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…","snippet":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex,…","categoryID":321,"dateInserted":"2023-09-28T16:04:56+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167649,"lastUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","format":"Rich","tagIDs":[238],"lastPost":{"discussionID":110933,"name":"Finance Tracking and Executive Reporting","url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","dateInserted":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+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":[{"tagID":238,"urlcode":"finance","name":"Finance"}]},{"discussionID":110932,"type":"question","name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","excerpt":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information.\" The column type…","snippet":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The…","categoryID":322,"dateInserted":"2023-09-28T15:51:34+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151182,"lastUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","format":"Rich","lastPost":{"discussionID":110932,"name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","dateInserted":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O5NB4NF1D746\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
Categories
Popular Tags
- Formulas10,888
- Project Management4,398
- Sheets3,769
- Reports2,643
- 形式2,435
- functionality2,178
- Automations1,934
- 它与操作1,754
- Enhancement Request1,572
- Support1,552
- Cell linking1,548
- Email Notifications1,461
- Account and User Management1,399
- Dashboards1,267
- Integrations1,243
- Conditional Formatting1,216
- Construction1,092
- API and Developers928
- Sharing and Collaboration904
- Workflows in Smartsheet873
- Manufacturing864
- Update Requests836
- Gantt View798
- Product Development794
- 附件789
This Week's Leaders
Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just a few highlights from the week: Community Champions & Overachievers took the stage: These program members not only came together during the…<\/p>\n<\/li>\n
Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…<\/p>\n<\/li>\n
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…<\/p>\n<\/li>\n
We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE while fostering an environment of diversity, equity, and inclusivity within the tech industry. Event details: Tuesday, Sept. 20 Time: 11:30 a.m.…<\/p>\n<\/li>\n
Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out your peers’ amazing submissions and show support to your favorites by using the Vote up and Awesome icon reactions, and you’ll be entered into a…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Announcements","componentName":"DiscussionListModule","componentProps":{"apiParams":{"pinned":true,"limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","sort":"-dateLastComment","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110900,"type":"discussion","name":"[RECAP] ENGAGE 2023: Potential Unlocked","excerpt":"Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just a few highlights from the week: Community Champions & Overachievers took the stage: These program members not only came together during the…","snippet":"Last week, thousands of you, along with Smartsheet staff came together for our annual conference, ENGAGE: Potential Unlocked to learn, connect and have fun doing it. Here are just…","categoryID":336,"dateInserted":"2023-09-28T01:56:27+00:00","dateUpdated":"2023-09-28T15:45:07+00:00","dateLastComment":"2023-09-28T14:52:57+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-09-28T15:15:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":126614,"lastUserID":166730,"lastUser":{"userID":166730,"name":"Monicacraven","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Monicacraven","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p-ldafb73jo!nDlQn-Shgro!geYRKbS4OXN","dateLastActive":"2023-09-28T14:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":4,"countViews":74,"score":3,"hot":3391785394,"url":"https:\/\/community.smartsheet.com\/discussion\/110900\/recap-engage-2023-potential-unlocked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110900\/recap-engage-2023-potential-unlocked","format":"Rich","tagIDs":[355],"lastPost":{"discussionID":110900,"commentID":397442,"name":"Re: [RECAP] ENGAGE 2023: Potential Unlocked","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397442#Comment_397442","dateInserted":"2023-09-28T14:52:57+00:00","insertUserID":166730,"insertUser":{"userID":166730,"name":"Monicacraven","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Monicacraven","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p-ldafb73jo!nDlQn-Shgro!geYRKbS4OXN","dateLastActive":"2023-09-28T14:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1WW8H4B1PDBC\/pxl-20230920-171712946-7e2.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PXL_20230920_171712946~2.jpg"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":336,"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events","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":3}],"tags":[{"tagID":355,"urlcode":"engage","name":"ENGAGE"}]},{"discussionID":109746,"type":"discussion","name":"September Question of the Month 💭 Join the conversation and receive a badge","excerpt":"Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own talk show, who would your first guest be and why? Could be anyone, a celebrity, politician or historical figure just to name a few . Get creative!…","snippet":"Hi everyone, We're ready to kick off September with a new question and opportunity for you to earn some badges and points while getting to know your peers! If you had your own…","categoryID":346,"dateInserted":"2023-08-31T22:25:46+00:00","dateUpdated":"2023-09-25T08:09:47+00:00","dateLastComment":"2023-09-28T13:25:01+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-09-28T15:15:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":167633,"lastUser":{"userID":167633,"name":"RileyWinzer","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/RileyWinzer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":113,"countViews":1353,"score":1,"hot":3389496347,"url":"https:\/\/community.smartsheet.com\/discussion\/109746\/september-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109746\/september-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[324,493],"lastPost":{"discussionID":109746,"commentID":397416,"name":"Re: September Question of the Month 💭 Join the conversation and receive a badge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397416#Comment_397416","dateInserted":"2023-09-28T13:25:01+00:00","insertUserID":167633,"insertUser":{"userID":167633,"name":"RileyWinzer","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/RileyWinzer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:47:42+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\/J6FYD7YWV5F3\/community-question-of-the-months-badges-09.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Community Question of the Months - Badges-09.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":["discussion","poll","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":110711,"type":"discussion","name":"New! TIME function for formulas","excerpt":"Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…","snippet":"Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format…","categoryID":335,"dateInserted":"2023-09-25T12:44:02+00:00","dateUpdated":"2023-09-25T21:13:56+00:00","dateLastComment":"2023-09-27T22:53:29+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-09-28T16:36:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-09-27T22:51:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":7,"countViews":157,"score":10,"hot":3391508251,"url":"https:\/\/community.smartsheet.com\/discussion\/110711\/new-time-function-for-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110711\/new-time-function-for-formulas","format":"Rich","tagIDs":[254,499],"lastPost":{"discussionID":110711,"commentID":397343,"name":"Re: New! TIME function for formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397343#Comment_397343","dateInserted":"2023-09-27T22:53:29+00:00","insertUserID":11072,"insertUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-09-27T22:51:42+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\/SDBJSXJ32A5A\/time.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"TIME.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":2},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":8}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":499,"urlcode":"time-calculation","name":"Time Calculation"}]},{"discussionID":110170,"type":"discussion","name":"Don't miss our ENGAGE Women in IT Luncheon event!","excerpt":"We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE while fostering an environment of diversity, equity, and inclusivity within the tech industry. Event details: Tuesday, Sept. 20 Time: 11:30 a.m.…","snippet":"We are thrilled to host our first Women in IT Luncheon hosted by Smartsheet leadership! This event, spotlighting women and gender minorities in IT, is designed to kick off ENGAGE…","categoryID":336,"dateInserted":"2023-09-12T20:25:48+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T22:34:10+00:00","insertUserID":121357,"insertUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":121357,"lastUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":13,"countViews":214,"score":4,"hot":3390413398,"url":"https:\/\/community.smartsheet.com\/discussion\/110170\/dont-miss-our-engage-women-in-it-luncheon-event","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110170\/dont-miss-our-engage-women-in-it-luncheon-event","format":"Rich","tagIDs":[355,593],"lastPost":{"discussionID":110170,"commentID":397342,"name":"Re: Don't miss our ENGAGE Women in IT Luncheon event!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397342#Comment_397342","dateInserted":"2023-09-27T22:34:10+00:00","insertUserID":121357,"insertUser":{"userID":121357,"name":"Claire Sternoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Sternoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/02P9RHS1QY7H\/nOQDOO7TPGI1G.jpg","dateLastActive":"2023-09-28T16:16:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M24UCRUCUVJG\/engage2023-women-in-it-badge.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ENGAGE2023-women-in-it-badge.png"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":336,"name":"Events","url":"https:\/\/community.smartsheet.com\/categories\/events","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":355,"urlcode":"engage","name":"ENGAGE"},{"tagID":593,"urlcode":"women-in-tech","name":"Women in Tech"}]},{"discussionID":109969,"type":"discussion","name":"Smartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!","excerpt":"Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out your peers’ amazing submissions and show support to your favorites by using the Vote up and Awesome icon reactions, and you’ll be entered into a…","snippet":"Today, we bring you part 2 of the Smartsheet Travel Diaries. We’re giving away a Smartsheet travel kit, perfect to take on all of your adventures! How to participate Check out…","categoryID":2,"dateInserted":"2023-09-07T15:43:14+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T14:37:31+00:00","insertUserID":161936,"insertUser":{"userID":161936,"name":"Rebeca S.","title":"Community Engagement Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Rebeca%20S.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqEp__PbH_o!bWcqW9OZSjo!5kR2l6b41gd","dateLastActive":"2023-09-28T16:39:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":149066,"lastUser":{"userID":149066,"name":"Cassi","url":"https:\/\/community.smartsheet.com\/profile\/Cassi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/27DD21PQ9H0Z\/nOQFD6KIZHJKL.jpg","dateLastActive":"2023-09-27T20:29:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":6,"countViews":211,"score":2,"hot":3389931045,"url":"https:\/\/community.smartsheet.com\/discussion\/109969\/smartsheet-travel-diaries-bonus-giveaway-win-a-travel-kit","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109969\/smartsheet-travel-diaries-bonus-giveaway-win-a-travel-kit","format":"Rich","tagIDs":[355,458],"lastPost":{"discussionID":109969,"commentID":397237,"name":"Re: Smartsheet Travel Diaries Bonus Giveaway - Win a Travel Kit!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397237#Comment_397237","dateInserted":"2023-09-27T14:37:31+00:00","insertUserID":149066,"insertUser":{"userID":149066,"name":"Cassi","url":"https:\/\/community.smartsheet.com\/profile\/Cassi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/27DD21PQ9H0Z\/nOQFD6KIZHJKL.jpg","dateLastActive":"2023-09-27T20:29:39+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":"General Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcement"}],"groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KU5WW077B5ZC\/engage-2023-communityhomepage-smartraveldiaries-badge-v1-icon.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ENGAGE 2023 Smartsheet Travel Diaries Badge showing a balloon and clouds"},"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":2,"name":"General Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcement","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":2}],"tags":[{"tagID":355,"urlcode":"engage","name":"ENGAGE"},{"tagID":458,"urlcode":"giveaway","name":"giveaway"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&pinned=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":24,"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- \nCan the Duration column type be converted to a column formula?<\/a>\n
I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:<\/p>\n<\/li>\n
- \n3 week look ahead including past due tasks<\/a>\n
I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…<\/p>\n<\/li>\n
- \nIssue when values from form are not added into the sheet<\/a>\n
I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.<\/p>\n<\/li>\n
- \nBilling Dashboard Help - Rows of Data shown on the Dashboard<\/a>\n
I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…<\/p>\n<\/li>\n
- \nHow to show multiple projects by phase and date rolled up in one dashboard?<\/a>\n
Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":110886,"type":"question","name":"Can the Duration column type be converted to a column formula?","excerpt":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","snippet":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","categoryID":322,"dateInserted":"2023-09-27T20:12:48+00:00","dateUpdated":"2023-09-27T22:20:08+00:00","dateLastComment":"2023-09-28T16:40:11+00:00","insertUserID":154243,"insertUser":{"userID":154243,"name":"hoodm","url":"https:\/\/community.smartsheet.com\/profile\/hoodm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T20:09:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391765379,"url":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","format":"Rich","lastPost":{"discussionID":110886,"commentID":397463,"name":"Re: Can the Duration column type be converted to a column formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397463#Comment_397463","dateInserted":"2023-09-28T16:40:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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\/NZLZTVZ6GGAY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:40:11+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":110884,"type":"question","name":"3 week look ahead including past due tasks","excerpt":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…","snippet":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start…","categoryID":321,"dateInserted":"2023-09-27T19:44:22+00:00","dateUpdated":"2023-09-27T19:47:05+00:00","dateLastComment":"2023-09-28T16:39:00+00:00","insertUserID":146897,"insertUser":{"userID":146897,"name":"MGreenPKWY","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MGreenPKWY","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":146897,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391763602,"url":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","format":"Rich","lastPost":{"discussionID":110884,"commentID":397462,"name":"Re: 3 week look ahead including past due tasks","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397462#Comment_397462","dateInserted":"2023-09-28T16:39:00+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EA2HP5NRXFJ0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:39:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":110883,"type":"question","name":"Issue when values from form are not added into the sheet","excerpt":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.","snippet":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the…","categoryID":322,"dateInserted":"2023-09-27T19:31:49+00:00","dateUpdated":"2023-09-27T22:19:31+00:00","dateLastComment":"2023-09-28T16:38:16+00:00","insertUserID":166371,"insertUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3391762805,"url":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","format":"Rich","lastPost":{"discussionID":110883,"commentID":397461,"name":"Re: Issue when values from form are not added into the sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397461#Comment_397461","dateInserted":"2023-09-28T16:38:16+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:38:16+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":110882,"type":"question","name":"Billing Dashboard Help - Rows of Data shown on the Dashboard","excerpt":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…","snippet":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure…","categoryID":322,"dateInserted":"2023-09-27T19:23:11+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:37:45+00:00","insertUserID":165295,"insertUser":{"userID":165295,"name":"cmc484","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/cmc484","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T19:20:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":8,"score":null,"hot":3391762256,"url":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","format":"Rich","lastPost":{"discussionID":110882,"commentID":397460,"name":"Re: Billing Dashboard Help - Rows of Data shown on the Dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397460#Comment_397460","dateInserted":"2023-09-28T16:37:45+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:37:45+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":110879,"type":"question","name":"How to show multiple projects by phase and date rolled up in one dashboard?","excerpt":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","snippet":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","categoryID":321,"dateInserted":"2023-09-27T17:43:26+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:34:52+00:00","insertUserID":167577,"insertUser":{"userID":167577,"name":"againes","url":"https:\/\/community.smartsheet.com\/profile\/againes","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKwXIGqAqKXl1d9FO5qkd3C9mV7IlhC8Yo2lULbyj5o=s96-c","dateLastActive":"2023-09-28T16:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3391756098,"url":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","format":"Rich","lastPost":{"discussionID":110879,"commentID":397459,"name":"Re: How to show multiple projects by phase and date rolled up in one dashboard?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397459#Comment_397459","dateInserted":"2023-09-28T16:34:52+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:34:52+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n Newest Questions<\/h2> <\/div>\n \n- \nForms<\/a>\n
When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…<\/p>\n<\/li>\n
- \nExtract text from a file string<\/a>\n
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…<\/p>\n<\/li>\n
- \nCount Per Specified Criteria and Date Range<\/a>\n
I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…<\/p>\n<\/li>\n
- \nFinance Tracking and Executive Reporting<\/a>\n
Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…<\/p>\n<\/li>\n
- \nI am trying to convert a formula to a column formula and keep getting the same error. Why?<\/a>\n
The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is "The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information." The column type…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110936,"type":"question","name":"Forms","excerpt":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…","snippet":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know…","categoryID":321,"dateInserted":"2023-09-28T16:26:24+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166642,"lastUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","format":"Rich","lastPost":{"discussionID":110936,"name":"Forms","url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","dateInserted":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+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":110935,"type":"question","name":"Extract text from a file string","excerpt":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…","snippet":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse…","categoryID":322,"dateInserted":"2023-09-28T16:08:07+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159135,"lastUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110935,"name":"Extract text from a file string","url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","dateInserted":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110934,"type":"question","name":"Count Per Specified Criteria and Date Range","excerpt":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…","snippet":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality…","categoryID":322,"dateInserted":"2023-09-28T16:05:58+00:00","dateUpdated":"2023-09-28T16:09:37+00:00","dateLastComment":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":167648,"lastUserID":167648,"lastUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":5,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","format":"Rich","lastPost":{"discussionID":110934,"name":"Count Per Specified Criteria and Date Range","url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","dateInserted":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/45Y1WDBJR58H\/data-quality-notes-gc.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data Quality Notes - GC.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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":110933,"type":"question","name":"Finance Tracking and Executive Reporting","excerpt":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…","snippet":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex,…","categoryID":321,"dateInserted":"2023-09-28T16:04:56+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167649,"lastUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","format":"Rich","tagIDs":[238],"lastPost":{"discussionID":110933,"name":"Finance Tracking and Executive Reporting","url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","dateInserted":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+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":[{"tagID":238,"urlcode":"finance","name":"Finance"}]},{"discussionID":110932,"type":"question","name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","excerpt":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information.\" The column type…","snippet":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The…","categoryID":322,"dateInserted":"2023-09-28T15:51:34+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151182,"lastUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","format":"Rich","lastPost":{"discussionID":110932,"name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","dateInserted":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O5NB4NF1D746\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
Categories
Popular Tags
- Formulas10,888
- Project Management4,398
- Sheets3,769
- Reports2,643
- 形式2,435
- functionality2,178
- Automations1,934
- 它与操作1,754
- Enhancement Request1,572
- Support1,552
- Cell linking1,548
- Email Notifications1,461
- Account and User Management1,399
- Dashboards1,267
- Integrations1,243
- Conditional Formatting1,216
- Construction1,092
- API and Developers928
- Sharing and Collaboration904
- Workflows in Smartsheet873
- Manufacturing864
- Update Requests836
- Gantt View798
- Product Development794
- 附件789
This Week's Leaders
I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:<\/p>\n<\/li>\n
I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…<\/p>\n<\/li>\n
I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.<\/p>\n<\/li>\n
I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…<\/p>\n<\/li>\n
Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Recent Discussions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"excludeHiddenCategories":true,"sort":"-dateLastComment","pinOrder":"mixed","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"]},"discussions":[{"discussionID":110886,"type":"question","name":"Can the Duration column type be converted to a column formula?","excerpt":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","snippet":"I would like to use the duration column type, but it's not letting me convert to a column formula. Is this possible? Formula:","categoryID":322,"dateInserted":"2023-09-27T20:12:48+00:00","dateUpdated":"2023-09-27T22:20:08+00:00","dateLastComment":"2023-09-28T16:40:11+00:00","insertUserID":154243,"insertUser":{"userID":154243,"name":"hoodm","url":"https:\/\/community.smartsheet.com\/profile\/hoodm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T20:09:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391765379,"url":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110886\/can-the-duration-column-type-be-converted-to-a-column-formula","format":"Rich","lastPost":{"discussionID":110886,"commentID":397463,"name":"Re: Can the Duration column type be converted to a column formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397463#Comment_397463","dateInserted":"2023-09-28T16:40:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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\/NZLZTVZ6GGAY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:40:11+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":110884,"type":"question","name":"3 week look ahead including past due tasks","excerpt":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start is in the past (I need this to only be for the incomplete tasks) But also add tasks for the next 3 weeks. I feel like I might be missing something…","snippet":"I created a row report from a Gannt schedule and I am I am trying to create a report that shows me the info below. Status is incomplete (is not equal to: Complete) Current Start…","categoryID":321,"dateInserted":"2023-09-27T19:44:22+00:00","dateUpdated":"2023-09-27T19:47:05+00:00","dateLastComment":"2023-09-28T16:39:00+00:00","insertUserID":146897,"insertUser":{"userID":146897,"name":"MGreenPKWY","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MGreenPKWY","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":146897,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3391763602,"url":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110884\/3-week-look-ahead-including-past-due-tasks","format":"Rich","lastPost":{"discussionID":110884,"commentID":397462,"name":"Re: 3 week look ahead including past due tasks","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397462#Comment_397462","dateInserted":"2023-09-28T16:39:00+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EA2HP5NRXFJ0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:39:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":110883,"type":"question","name":"Issue when values from form are not added into the sheet","excerpt":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.","snippet":"I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the…","categoryID":322,"dateInserted":"2023-09-27T19:31:49+00:00","dateUpdated":"2023-09-27T22:19:31+00:00","dateLastComment":"2023-09-28T16:38:16+00:00","insertUserID":166371,"insertUser":{"userID":166371,"name":"fb_smd","title":"Market Analyst","url":"https:\/\/community.smartsheet.com\/profile\/fb_smd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3391762805,"url":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110883\/issue-when-values-from-form-are-not-added-into-the-sheet","format":"Rich","lastPost":{"discussionID":110883,"commentID":397461,"name":"Re: Issue when values from form are not added into the sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397461#Comment_397461","dateInserted":"2023-09-28T16:38:16+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:38:16+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":110882,"type":"question","name":"Billing Dashboard Help - Rows of Data shown on the Dashboard","excerpt":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month. I saw someone using =INDEX(COLLECT, but I don't know how that would translate to…","snippet":"I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure…","categoryID":322,"dateInserted":"2023-09-27T19:23:11+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:37:45+00:00","insertUserID":165295,"insertUser":{"userID":165295,"name":"cmc484","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/cmc484","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T19:20:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":8,"score":null,"hot":3391762256,"url":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110882\/billing-dashboard-help-rows-of-data-shown-on-the-dashboard","format":"Rich","lastPost":{"discussionID":110882,"commentID":397460,"name":"Re: Billing Dashboard Help - Rows of Data shown on the Dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397460#Comment_397460","dateInserted":"2023-09-28T16:37:45+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+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-09-28T16:37:45+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":110879,"type":"question","name":"How to show multiple projects by phase and date rolled up in one dashboard?","excerpt":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","snippet":"Does anyone know how I can show a summary of project phases by month? I need a way to understand the summary of how multiple projects are progressing.","categoryID":321,"dateInserted":"2023-09-27T17:43:26+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:34:52+00:00","insertUserID":167577,"insertUser":{"userID":167577,"name":"againes","url":"https:\/\/community.smartsheet.com\/profile\/againes","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKwXIGqAqKXl1d9FO5qkd3C9mV7IlhC8Yo2lULbyj5o=s96-c","dateLastActive":"2023-09-28T16:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3391756098,"url":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110879\/how-to-show-multiple-projects-by-phase-and-date-rolled-up-in-one-dashboard","format":"Rich","lastPost":{"discussionID":110879,"commentID":397459,"name":"Re: How to show multiple projects by phase and date rolled up in one dashboard?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397459#Comment_397459","dateInserted":"2023-09-28T16:34:52+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-28T16:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-28T16:34:52+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&excludeHiddenCategories=1&siteSectionID=0&sort=-dateLastComment&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n
\n Newest Questions<\/h2> <\/div>\n
Newest Questions<\/h2> <\/div>\n \n- \nForms<\/a>\n
When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…<\/p>\n<\/li>\n
- \nExtract text from a file string<\/a>\n
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…<\/p>\n<\/li>\n
- \nCount Per Specified Criteria and Date Range<\/a>\n
I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…<\/p>\n<\/li>\n
- \nFinance Tracking and Executive Reporting<\/a>\n
Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…<\/p>\n<\/li>\n
- \nI am trying to convert a formula to a column formula and keep getting the same error. Why?<\/a>\n
The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is "The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information." The column type…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110936,"type":"question","name":"Forms","excerpt":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…","snippet":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know…","categoryID":321,"dateInserted":"2023-09-28T16:26:24+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166642,"lastUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","format":"Rich","lastPost":{"discussionID":110936,"name":"Forms","url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","dateInserted":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+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":110935,"type":"question","name":"Extract text from a file string","excerpt":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…","snippet":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse…","categoryID":322,"dateInserted":"2023-09-28T16:08:07+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159135,"lastUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110935,"name":"Extract text from a file string","url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","dateInserted":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110934,"type":"question","name":"Count Per Specified Criteria and Date Range","excerpt":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…","snippet":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality…","categoryID":322,"dateInserted":"2023-09-28T16:05:58+00:00","dateUpdated":"2023-09-28T16:09:37+00:00","dateLastComment":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":167648,"lastUserID":167648,"lastUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":5,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","format":"Rich","lastPost":{"discussionID":110934,"name":"Count Per Specified Criteria and Date Range","url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","dateInserted":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/45Y1WDBJR58H\/data-quality-notes-gc.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data Quality Notes - GC.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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":110933,"type":"question","name":"Finance Tracking and Executive Reporting","excerpt":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…","snippet":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex,…","categoryID":321,"dateInserted":"2023-09-28T16:04:56+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167649,"lastUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","format":"Rich","tagIDs":[238],"lastPost":{"discussionID":110933,"name":"Finance Tracking and Executive Reporting","url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","dateInserted":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+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":[{"tagID":238,"urlcode":"finance","name":"Finance"}]},{"discussionID":110932,"type":"question","name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","excerpt":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information.\" The column type…","snippet":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The…","categoryID":322,"dateInserted":"2023-09-28T15:51:34+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151182,"lastUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","format":"Rich","lastPost":{"discussionID":110932,"name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","dateInserted":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O5NB4NF1D746\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…<\/p>\n<\/li>\n
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…<\/p>\n<\/li>\n
I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…<\/p>\n<\/li>\n
Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…<\/p>\n<\/li>\n
The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is "The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information." The column type…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","slotType":"a","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":110936,"type":"question","name":"Forms","excerpt":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know their name and email? or one or the other? Or should there be a field on the form asking them for that information? When someone fills out a form, at…","snippet":"When someone fills out a form, is there a way to know when they filled it out? When someone fills out a form, is there a way to know who filled it out? is there a way to know…","categoryID":321,"dateInserted":"2023-09-28T16:26:24+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166642,"lastUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","format":"Rich","lastPost":{"discussionID":110936,"name":"Forms","url":"https:\/\/community.smartsheet.com\/discussion\/110936\/forms","dateInserted":"2023-09-28T16:26:24+00:00","insertUserID":166642,"insertUser":{"userID":166642,"name":"JenaW","url":"https:\/\/community.smartsheet.com\/profile\/JenaW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:26:25+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":110935,"type":"question","name":"Extract text from a file string","excerpt":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…","snippet":"Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents\/Training\/Investigators\/Rhodes, Meredith\/CV I would like to parse…","categoryID":322,"dateInserted":"2023-09-28T16:08:07+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159135,"lastUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110935,"name":"Extract text from a file string","url":"https:\/\/community.smartsheet.com\/discussion\/110935\/extract-text-from-a-file-string","dateInserted":"2023-09-28T16:08:07+00:00","insertUserID":159135,"insertUser":{"userID":159135,"name":"Meredith Rhodes","url":"https:\/\/community.smartsheet.com\/profile\/Meredith%20Rhodes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nAHTX1zFB30!3-DcP2_U_mU!0YuvNuMRG8s","dateLastActive":"2023-09-28T16:31:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110934,"type":"question","name":"Count Per Specified Criteria and Date Range","excerpt":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality issues per provider agency each month. The data quality issues are entered through a Smartsheet form and displayed in a report. Each row signifies…","snippet":"I am trying to create a formula to count the number of data quality issues per provider agency in a Smartsheet report. We would like to keep track of the number of data quality…","categoryID":322,"dateInserted":"2023-09-28T16:05:58+00:00","dateUpdated":"2023-09-28T16:09:37+00:00","dateLastComment":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":167648,"lastUserID":167648,"lastUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":5,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","format":"Rich","lastPost":{"discussionID":110934,"name":"Count Per Specified Criteria and Date Range","url":"https:\/\/community.smartsheet.com\/discussion\/110934\/count-per-specified-criteria-and-date-range","dateInserted":"2023-09-28T16:05:58+00:00","insertUserID":167648,"insertUser":{"userID":167648,"name":"jewolf","title":"Program Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/jewolf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:27:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/45Y1WDBJR58H\/data-quality-notes-gc.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data Quality Notes - GC.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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":110933,"type":"question","name":"Finance Tracking and Executive Reporting","excerpt":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budget and forecast, ROI \/ IRR calculations, etc. I know there templates I can explore but I attended ENGAGE last week and was…","snippet":"Hi Team! I am looking for any templates \/ examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex,…","categoryID":321,"dateInserted":"2023-09-28T16:04:56+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167649,"lastUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","format":"Rich","tagIDs":[238],"lastPost":{"discussionID":110933,"name":"Finance Tracking and Executive Reporting","url":"https:\/\/community.smartsheet.com\/discussion\/110933\/finance-tracking-and-executive-reporting","dateInserted":"2023-09-28T16:04:56+00:00","insertUserID":167649,"insertUser":{"userID":167649,"name":"AdrianCanales","title":"Finance","url":"https:\/\/community.smartsheet.com\/profile\/AdrianCanales","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T16:03:55+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":[{"tagID":238,"urlcode":"finance","name":"Finance"}]},{"discussionID":110932,"type":"question","name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","excerpt":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The column formula syntax isn’t quite right, see our help article https:\/\/help.smartsheet.com\/articles\/2481944 for more information.\" The column type…","snippet":"The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1) The error message I am getting is \"The…","categoryID":322,"dateInserted":"2023-09-28T15:51:34+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151182,"lastUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","format":"Rich","lastPost":{"discussionID":110932,"name":"I am trying to convert a formula to a column formula and keep getting the same error. Why?","url":"https:\/\/community.smartsheet.com\/discussion\/110932\/i-am-trying-to-convert-a-formula-to-a-column-formula-and-keep-getting-the-same-error-why","dateInserted":"2023-09-28T15:51:34+00:00","insertUserID":151182,"insertUser":{"userID":151182,"name":"ajuelsgaard","url":"https:\/\/community.smartsheet.com\/profile\/ajuelsgaard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jD9qI_ZEy_o!ZBFrGdYxZ3o!H7BDI1juIh8","dateLastActive":"2023-09-28T15:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O5NB4NF1D746\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&slotType=a&type%5B0%5D=question&excludeHiddenCategories=1&siteSectionID=0&sort=-dateInserted&limit=5&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":10000,"limit":5},"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
Explore. Ask. Answer
Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
Discussion List
Categories
Popular Tags
- Formulas10,888
- Project Management4,398
- Sheets3,769
- Reports2,643
- 形式2,435
- functionality2,178
- Automations1,934
- 它与操作1,754
- Enhancement Request1,572
- Support1,552
- Cell linking1,548
- Email Notifications1,461
- Account and User Management1,399
- Dashboards1,267
- Integrations1,243
- Conditional Formatting1,216
- Construction1,092
- API and Developers928
- Sharing and Collaboration904
- Workflows in Smartsheet873
- Manufacturing864
- Update Requests836
- Gantt View798
- Product Development794
- 附件789
This Week's Leaders
