Formulas

\"N\/A\"","excerpt":"Hi, I'm struggling to combine a SUM and a COUNT together (keeps returning an error). =SUM([CELL 1]22:[CELL 4]22) \/ COUNTIF([CELL 1]22:[CELL 4]22, <>\"N\/A\") This returns a #DIVIDE BY ZERO. CELL 1 to CELL 4 could contain the numbers 1 to 5 or N\/A. The end result is to provide a percentage out of 100% for the total cells with…","categoryID":319,"dateInserted":"2017-12-19T05:02:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-19T19:51:26+00:00","insertUserID":3945,"insertUser":{"userID":3945,"name":"Colin Janssen","url":"https:\/\/community.smartsheet.com\/profile\/Colin%20Janssen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-09T04:23:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":3945,"lastUser":{"userID":3945,"name":"Colin Janssen","url":"https:\/\/community.smartsheet.com\/profile\/Colin%20Janssen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-09T04:23:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":266,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/16971\/count-where-cells-n-a","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16971\/count-where-cells-n-a","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":16871,"type":"discussion","name":"Formatting with alerts","excerpt":"I need to do the combination of formatting with and alert, but seem to have hit a wall. If column \"delivery type\"= selection \"o\" and column \"1st delivery\" has a date that is past due then turn \"1st delivery\" to red and send an alert to the contact in columns \"PM\" and a particular individual. Any help would be appreciated.","categoryID":319,"dateInserted":"2017-12-15T11:56:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-19T10:13:04+00:00","insertUserID":32476,"insertUser":{"userID":32476,"name":"kellyhatcher","url":"https:\/\/community.smartsheet.com\/profile\/kellyhatcher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-19T11:34:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":32476,"lastUser":{"userID":32476,"name":"kellyhatcher","url":"https:\/\/community.smartsheet.com\/profile\/kellyhatcher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-19T11:34:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/16871\/formatting-with-alerts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16871\/formatting-with-alerts","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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":16836,"type":"discussion","name":"Restrict to List values only","excerpt":"I noticed when I create a drop down list for contacts and select \"Restrict to list values only\" it works great in the main sheet, but when I view the same column in a report it is not restricted to list values only. All the contacts shown on that sheet also shows in that list. Am I doing something wrong? or is there a…","categoryID":319,"dateInserted":"2017-12-14T14:23:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-18T17:21:06+00:00","insertUserID":11112,"insertUser":{"userID":11112,"name":"Guliker","url":"https:\/\/community.smartsheet.com\/profile\/Guliker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-14T14:17:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":402,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16836\/restrict-to-list-values-only","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16836\/restrict-to-list-values-only","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":207,"urlcode":"sales","name":"Sales"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":16801,"type":"discussion","name":"Sum columns for each month","excerpt":"I would like to summarize the cost of each month in the current year. columns for each month and year. I do not get the formula: =SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; MONTH(@cell) = [Årlige utførelser]28; YEAR(@cell) = [Måneder for utførsel]28) Please come with suggestions","categoryID":319,"dateInserted":"2017-12-14T10:24:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-18T15:15:22+00:00","insertUserID":13686,"insertUser":{"userID":13686,"name":"post13686","url":"https:\/\/community.smartsheet.com\/profile\/post13686","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-28T04:18:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":14396,"lastUser":{"userID":14396,"name":"Robert S.","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/15\/71\/n1571b9c12b9098ef693fffa5813f0c39.jpg","dateLastActive":"2020-02-28T21:06:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":254,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/16801\/sum-columns-for-each-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16801\/sum-columns-for-each-month","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-12\/1c\/8b\/1c8b8d4e0aada30de38ce797185800de.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Skjermbilde.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"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":16716,"type":"discussion","name":"Need a formula to add a today's date in a date column","excerpt":"Hello Everyone, I am looking for a formula that will add today's date if certain criteria has been met. If \"Approved\" or \"Denied\" has been entered into the Status column I would like today's date to automatically be entered in the date column. Thanks in advance. Stephanie ","categoryID":319,"dateInserted":"2017-12-12T15:35:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-18T14:17:43+00:00","insertUserID":325,"insertUser":{"userID":325,"name":"Stephanie Taylor","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/00\/78\/n00785bd3cab80583fbe881cf23761eac.jpg","dateLastActive":"2023-08-15T13:02:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":325,"lastUser":{"userID":325,"name":"Stephanie Taylor","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/00\/78\/n00785bd3cab80583fbe881cf23761eac.jpg","dateLastActive":"2023-08-15T13:02:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":934,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/16716\/need-a-formula-to-add-a-todays-date-in-a-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16716\/need-a-formula-to-add-a-todays-date-in-a-date-column","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":16881,"type":"discussion","name":"Needing an \"If, Than\" formula for multiple variables","excerpt":"I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all \"Open\" issues + \"Reviewed\" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, \"Reviewed\" I get an unparseable error. Here is what I have:…","categoryID":319,"dateInserted":"2017-12-15T13:58:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-15T14:25:04+00:00","insertUserID":14986,"insertUser":{"userID":14986,"name":"mmurphy14986","url":"https:\/\/community.smartsheet.com\/profile\/mmurphy14986","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-12\/1e\/5d\/n1e5d161a2fad56caeffb1475ea0679bc.jpg","dateLastActive":"2018-11-29T12:41:06+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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":3,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/16881\/needing-an-if-than-formula-for-multiple-variables","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16881\/needing-an-if-than-formula-for-multiple-variables","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"},{"tagID":440,"urlcode":"project-management","name":"Project 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":16786,"type":"discussion","name":"Auto populating Formula Issues","excerpt":"I have an existing sheet with formulas to compute \"netdays\" left for a task, the task and variables live on the same row. That sheet has a form which allows for a user to add to the sheet a new task and assign, within the form, a start and end date. These dates are the variables that contribute to the formula. My issue is…","categoryID":319,"dateInserted":"2017-12-14T09:36:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-15T13:13:41+00:00","insertUserID":26571,"insertUser":{"userID":26571,"name":"Theater Scooter","url":"https:\/\/community.smartsheet.com\/profile\/Theater%20Scooter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-09T12:45:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16786\/auto-populating-formula-issues","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16786\/auto-populating-formula-issues","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":204,"urlcode":"forms","name":"Forms"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"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":16731,"type":"discussion","name":"Formula to move data to another column","excerpt":"I would like to move data from one column to another. Is there a formula that can do that? I may append to existing data or replace it depending on options. If there's no formula, how can this be done manually? I tried cut\/paste, but it did not work.Thank you.","categoryID":319,"dateInserted":"2017-12-13T09:47:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-14T18:05:17+00:00","insertUserID":32571,"insertUser":{"userID":32571,"name":"Vlad","url":"https:\/\/community.smartsheet.com\/profile\/Vlad","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-13T09:44:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":58,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16731\/formula-to-move-data-to-another-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16731\/formula-to-move-data-to-another-column","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":16746,"type":"discussion","name":"Referencing formula for other sheets?","excerpt":"Is it possible to build a formula that references other cells\/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet\/JIRA connector rows are automatically and constantly being added, so I…","categoryID":319,"dateInserted":"2017-12-13T12:09:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-13T13:24:50+00:00","insertUserID":14986,"insertUser":{"userID":14986,"name":"mmurphy14986","url":"https:\/\/community.smartsheet.com\/profile\/mmurphy14986","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-12\/1e\/5d\/n1e5d161a2fad56caeffb1475ea0679bc.jpg","dateLastActive":"2018-11-29T12:41:06+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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16746\/referencing-formula-for-other-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16746\/referencing-formula-for-other-sheets","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":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">