Services

0","excerpt":"I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have. =IF(AVG({Field Scheduler Test Range 1}), 0, \"Same Day\", (AVG({Field Scheduler Test…","categoryID":322,"dateInserted":"2019-10-22T12:06:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-22T16:54:21+00:00","insertUserID":82316,"insertUser":{"userID":82316,"name":"michael.vanhuss","url":"https:\/\/community.smartsheet.com\/profile\/michael.vanhuss","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-22T11:53:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:58:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":67,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/60936\/average-days-returns-1-value-if-0-and-the-average-value-if-0","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60936\/average-days-returns-1-value-if-0-and-the-average-value-if-0","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":281,"urlcode":"Support","name":"Support"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":60451,"type":"discussion","name":"Summary Fields: Percentage of Completed Checkboxes","excerpt":"I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…","categoryID":322,"dateInserted":"2019-10-17T09:38:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-18T04:31:24+00:00","insertUserID":107801,"insertUser":{"userID":107801,"name":"Allison Caskey","url":"https:\/\/community.smartsheet.com\/profile\/Allison%20Caskey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-16T11:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1954,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/60451\/summary-fields-percentage-of-completed-checkboxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60451\/summary-fields-percentage-of-completed-checkboxes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/1d\/8c\/1d8c9edd6cb595d4050b37c6d83b85b0.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2019-10-16 at 11.10.17 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":51591,"type":"discussion","name":"Inventory","excerpt":"Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.","categoryID":321,"dateInserted":"2019-06-26T11:25:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-14T04:13:02+00:00","insertUserID":93946,"insertUser":{"userID":93946,"name":"meredithm@oldmilliron","url":"https:\/\/community.smartsheet.com\/profile\/meredithm%40oldmilliron","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-26T11:20:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":94,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/51591\/inventory","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/51591\/inventory","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":291,"urlcode":"Webinars","name":"Webinars"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":6114,"type":"discussion","name":"Capturing the Date and Time a Cell in Smartsheet was created or modified?","excerpt":" How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.","categoryID":318,"dateInserted":"2016-09-21T05:26:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-11T16:15:01+00:00","insertUserID":8388,"insertUser":{"userID":8388,"name":"John Francis Alita","url":"https:\/\/community.smartsheet.com\/profile\/John%20Francis%20Alita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/ed\/53\/ned533c8f3fa0643f909b47e8a08fae6a.jpg","dateLastActive":"2019-04-25T01:37:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":2798,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/6114\/capturing-the-date-and-time-a-cell-in-smartsheet-was-created-or-modified","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6114\/capturing-the-date-and-time-a-cell-in-smartsheet-was-created-or-modified","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/fb\/82\/fb82eba9821f5664842e5b513e188056.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"screenshot.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":271,"urlcode":"Services","name":"Services"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">