公式

0, ([C6]14 \/ [C6]14)) Thanks","categoryID":322,"dateInserted":"2018-04-19T15:48:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-19T16:53:31+00:00","insertUserID":41966,"insertUser":{"userID":41966,"name":"Tony Barthelemy","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Barthelemy","photoUrl":"https:\/\/lh3.googleusercontent.com\/-XdUIqdMkCWA\/AAAAAAAAAAI\/AAAAAAAAAAA\/4252rscbv5M\/photo.jpg","dateLastActive":"2021-02-21T20:22:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-12-20T16:47:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":58,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/23956\/decimal","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23956\/decimal","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"}],"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":23936,"type":"discussion","name":"#Unparseable with If statement","excerpt":"I keep getting # Unparseable error with this if statement: =IF(RC@row= “RFI-1”, \"*Request For Information*” ,IF(RC@row = “RFI-2”, “**Request For Information, Second Attempt**” ,IF(RC@row = “RFI-3”, “***Request For Information, Final Attempt***” ,IF(RC@row= “IFA-1”, \"*Request For Approval*” ,IF(RC@row = “IFA-2”, “**Request…","categoryID":322,"dateInserted":"2018-04-19T13:25:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-19T15:43:53+00:00","insertUserID":31866,"insertUser":{"userID":31866,"name":"aaboueid","url":"https:\/\/community.smartsheet.com\/profile\/aaboueid","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!kvFef2Qedvo!p_Hd6ZxI3n4!BRZh6a6R2Z4","dateLastActive":"2021-04-14T15:49:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-12-20T16:47:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":99,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/23936\/unparseable-with-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23936\/unparseable-with-if-statement","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"}],"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":9211,"type":"discussion","name":"RYG Parent\/Child Row Status Correlation","excerpt":"Hello, I'm trying to have a formula in my parent row status (red, yellow, green) where it will answer with a \"summary\" of all the children status. For example, if all 5 children rows were red then the parent row status would turn red. If 3 children rows were yellow and 2 children rows were red then the parent row status…","categoryID":319,"dateInserted":"2017-05-11T15:33:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-19T15:33:26+00:00","insertUserID":14901,"insertUser":{"userID":14901,"name":"amclaren","url":"https:\/\/community.smartsheet.com\/profile\/amclaren","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-26T16:43:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":115,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/9211\/ryg-parent-child-row-status-correlation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/9211\/ryg-parent-child-row-status-correlation","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":23886,"type":"discussion","name":"Checkbox based off of dropdown selection.","excerpt":"I'm trying to create a formula in a checkbox column. This column is called complete. I would like the complete column to automatically check once one of two statuses from a status column is selected. The status column has a number of statuses, but the two I need are \"Hold\/Cancelled\" and \"Complete\". I created an IF…","categoryID":322,"dateInserted":"2018-04-18T17:22:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-19T11:05:02+00:00","insertUserID":45291,"insertUser":{"userID":45291,"name":"jon.peters","url":"https:\/\/community.smartsheet.com\/profile\/jon.peters","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-21T17:03:53+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":45291,"lastUser":{"userID":45291,"name":"jon.peters","url":"https:\/\/community.smartsheet.com\/profile\/jon.peters","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-21T17:03:53+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":117,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/23886\/checkbox-based-off-of-dropdown-selection","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23886\/checkbox-based-off-of-dropdown-selection","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"}],"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":22596,"type":"discussion","name":"Formulas","excerpt":"I'm completely stuck on this one and not even sure it is possible. I am trying to compile data from a sheet to be used in a dashboard to show total time to complete \"phases\" of a project. I need a formula that is able to determine \"Active\" clients and the \"Phase\" that they are in, and then the processing time for that…","categoryID":322,"dateInserted":"2018-04-03T13:38:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-19T08:16:11+00:00","insertUserID":35576,"insertUser":{"userID":35576,"name":"Heather Dixon","url":"https:\/\/community.smartsheet.com\/profile\/Heather%20Dixon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T11:58:22+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":35576,"lastUser":{"userID":35576,"name":"Heather Dixon","url":"https:\/\/community.smartsheet.com\/profile\/Heather%20Dixon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T11:58:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":27,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/22596\/formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22596\/formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-04\/9d\/0b\/9d0b9ece38e11d2f8a39ddfe0dff766f.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data.JPG"},"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"}],"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":23871,"type":"discussion","name":"SUMIFS AND & OR","excerpt":"I am trying to sum a single column with the following conditions: Year = 2018 AND Division = North AND Project Status = Client Approvel OR Project Status = Business Case Submitted OR Project Status = Under Development =SUMIFS([Net Project Savings]10:[Net Project Savings]1549, [Year Final Business Case Submitted]10:[Year…","categoryID":322,"dateInserted":"2018-04-18T15:37:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-18T18:22:30+00:00","insertUserID":45261,"insertUser":{"userID":45261,"name":"DTreacy","url":"https:\/\/community.smartsheet.com\/profile\/DTreacy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-18T15:29:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":3079,"lastUser":{"userID":3079,"name":"Dave Stanley","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20Stanley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/46\/7d\/n467dd8d11cc984a7c66ed30bf40aea45.jpg","dateLastActive":"2022-06-09T04:44:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":913,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/23871\/sumifs-and-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23871\/sumifs-and-or","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"}],"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":23866,"type":"discussion","name":"Need Help with formula: One of 3 values based on a high and low threshold","excerpt":"Trying to set up a formula (IF?) where the value of a cell is either 0, 3 or 5 determined by the value of a result and if it is below a minimum threshold, in the middle or above a high threshold. For the attached example, the first KPI result is 100% so it receives 5, second result is 4 falls in the middle so receives 3,…","categoryID":322,"dateInserted":"2018-04-18T14:35:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-18T16:31:58+00:00","insertUserID":12291,"insertUser":{"userID":12291,"name":"Randy Van Winkle","url":"https:\/\/community.smartsheet.com\/profile\/Randy%20Van%20Winkle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WoDan6wmWuY!3djbP0w0lZY!n5rUfEeMbtB","dateLastActive":"2021-06-01T16:00:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11270,"lastUser":{"userID":11270,"name":"Matt Hagler","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Hagler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/94\/e2\/n94e2afbdd827241f05f4197b47d5c461.jpg","dateLastActive":"2018-05-14T12:16:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/23866\/need-help-with-formula-one-of-3-values-based-on-a-high-and-low-threshold","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23866\/need-help-with-formula-one-of-3-values-based-on-a-high-and-low-threshold","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-04\/a6\/ca\/a6cae39e8d3f391e52e480a32921a026.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture 1 of 3 based on thresholds.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":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":23846,"type":"discussion","name":"Referencing Another Sheet: Count","excerpt":"Good day all: I am counting number Rows in another sheet. However, I do not want to include the Parent or Grand Parent Row in that count, just the children and grandchildren. thoughts on how I would structure this formula? Thanks My formula =COUNTIFS({Mi-Config 7.2 WBS Range 1}, 1)","categoryID":322,"dateInserted":"2018-04-18T11:33:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-18T14:19:52+00:00","insertUserID":41966,"insertUser":{"userID":41966,"name":"Tony Barthelemy","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Barthelemy","photoUrl":"https:\/\/lh3.googleusercontent.com\/-XdUIqdMkCWA\/AAAAAAAAAAI\/AAAAAAAAAAA\/4252rscbv5M\/photo.jpg","dateLastActive":"2021-02-21T20:22:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":41966,"lastUser":{"userID":41966,"name":"Tony Barthelemy","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Barthelemy","photoUrl":"https:\/\/lh3.googleusercontent.com\/-XdUIqdMkCWA\/AAAAAAAAAAI\/AAAAAAAAAAA\/4252rscbv5M\/photo.jpg","dateLastActive":"2021-02-21T20:22:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":69,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/23846\/referencing-another-sheet-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23846\/referencing-another-sheet-count","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"}],"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":23551,"type":"discussion","name":"Updating Dashboard","excerpt":"So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be built it is not feasible to manually re-point the widgets to the latest data. So I need a workaround. Given that the widgets…","categoryID":322,"dateInserted":"2018-04-13T09:56:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-18T13:02:14+00:00","insertUserID":44541,"insertUser":{"userID":44541,"name":"Grant","url":"https:\/\/community.smartsheet.com\/profile\/Grant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-31T16:41:12+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":44541,"lastUser":{"userID":44541,"name":"Grant","url":"https:\/\/community.smartsheet.com\/profile\/Grant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-31T16:41:12+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1264,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/23551\/updating-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23551\/updating-dashboard","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-04\/50\/09\/5009f755e34651e2fa66e0722c605bd6.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"dashboard.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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}">