公式和函数
被公式难住了?寻求帮助或找一些例子,看看别人是如何使用公式来解决类似的问题的。
讨论表
= 0, [Health Score]12 < =1.5), [Status]12, \"Red\", IF([Health Score]12 >1.5, [Health Score]12 <=2.9),[Status]12, \"Yellow\",…","categoryID":322,"dateInserted":"2018-08-07T12:56:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-08T15:17:26+00:00","insertUserID":57161,"insertUser":{"userID":57161,"name":"Kelly Lawler","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Lawler","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DWKYnE3nQ!pbdXqcW2tLo!TqS_gN6IzGm","dateLastActive":"2020-03-10T20:16:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":57161,"lastUser":{"userID":57161,"name":"Kelly Lawler","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Lawler","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DWKYnE3nQ!pbdXqcW2tLo!TqS_gN6IzGm","dateLastActive":"2020-03-10T20:16:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":126,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/30201\/automating-rgb-balls-from-value-scale","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30201\/automating-rgb-balls-from-value-scale","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":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":30241,"type":"discussion","name":"Escalation Alerts or Notifications","excerpt":"Is it possible - whether in the Alerts\/notifications or with a formula, to create an escalation based on inactivity of entries. Example: Operators enter the date when equipment is cleaned. this is required weekly. If 2 weeks are missed for entries (14 days), then I want a notification sent via email to their manager.…","categoryID":322,"dateInserted":"2018-08-07T17:30:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-08T09:10:31+00:00","insertUserID":28141,"insertUser":{"userID":28141,"name":"Elizabeth Aird","url":"https:\/\/community.smartsheet.com\/profile\/Elizabeth%20Aird","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T15:50:40+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-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":428,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/30241\/escalation-alerts-or-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30241\/escalation-alerts-or-notifications","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"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":20436,"type":"discussion","name":"Converting text to date via formula","excerpt":"Good afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the cell in the appropriate \"Confirmed\" column is marked YES. There are 4 \"Confirmed\"…","categoryID":322,"dateInserted":"2018-02-28T14:29:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-07T21:36:19+00:00","insertUserID":23116,"insertUser":{"userID":23116,"name":"kym4639","url":"https:\/\/community.smartsheet.com\/profile\/kym4639","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-09T10:29:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":57291,"lastUser":{"userID":57291,"name":"smantics","url":"https:\/\/community.smartsheet.com\/profile\/smantics","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-07T21:32:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1871,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/20436\/converting-text-to-date-via-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20436\/converting-text-to-date-via-formula","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":30166,"type":"discussion","name":"Building a red ledger","excerpt":"My apologies I am not even sure how to search of this, but I am trying to build a red ledger. Basically have it set up so there is a required sale every day and anything under, shows negative, anything over just shows zero. So I have 1 column that has the number sold, next is sum of column1 - 5000, the last is column2\/100.…","categoryID":322,"dateInserted":"2018-08-07T09:13:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-07T14:51:50+00:00","insertUserID":54966,"insertUser":{"userID":54966,"name":"Tom deGroh","url":"https:\/\/community.smartsheet.com\/profile\/Tom%20deGroh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/2e\/00\/n2e003d3574569015070827124df77f2e.jpg","dateLastActive":"2018-10-15T15:54:45+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-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":79,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/30166\/building-a-red-ledger","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30166\/building-a-red-ledger","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":30171,"type":"discussion","name":"Days Remaining Calculation","excerpt":"How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8\/17\/18 and each day I want it to show how many days are remaining until 8\/17\/18. ","categoryID":322,"dateInserted":"2018-08-07T09:22:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-07T13:13:33+00:00","insertUserID":57111,"insertUser":{"userID":57111,"name":"Corey Fletcher","url":"https:\/\/community.smartsheet.com\/profile\/Corey%20Fletcher","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3rjfvwxGnDY!mp_Y3_mxWvw!BsmFIF6QTmh","dateLastActive":"2022-01-13T17:20:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":57111,"lastUser":{"userID":57111,"name":"Corey Fletcher","url":"https:\/\/community.smartsheet.com\/profile\/Corey%20Fletcher","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3rjfvwxGnDY!mp_Y3_mxWvw!BsmFIF6QTmh","dateLastActive":"2022-01-13T17:20:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":4567,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/30171\/days-remaining-calculation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30171\/days-remaining-calculation","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":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":29676,"type":"discussion","name":"index match formula not working","excerpt":"Hi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a \"contact list\" column type, and the column used for the formula is a Text type. I assume the formula is not working due to the type, is there another way around this? =INDEX({Mfg Rev 18 area}, MATCH([Start Date]3, {start date…","categoryID":322,"dateInserted":"2018-07-31T15:59:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-07T11:34:49+00:00","insertUserID":8236,"insertUser":{"userID":8236,"name":"David Friesen","url":"https:\/\/community.smartsheet.com\/profile\/David%20Friesen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-01T19:02:59+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":false,"sink":false,"countComments":5,"countViews":519,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/29676\/index-match-formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29676\/index-match-formula-not-working","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":30156,"type":"discussion","name":"Column Properties using Symbols","excerpt":"Anyone here used the 6-state Pain Scale in their sheets\/dashboards? We plan on using this for our customer satisfaction survey and I want to know how you guys came up with the formula. If there's an article available around this might be helpful too. Best, Grace","categoryID":322,"dateInserted":"2018-08-07T07:24:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-07T08:45:50+00:00","insertUserID":42606,"insertUser":{"userID":42606,"name":"Grace","url":"https:\/\/community.smartsheet.com\/profile\/Grace","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-14T08:25:04+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-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":370,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/30156\/column-properties-using-symbols","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30156\/column-properties-using-symbols","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":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":30086,"type":"discussion","name":"Trying to do a group IF statment","excerpt":"Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the…","categoryID":322,"dateInserted":"2018-08-06T12:30:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-06T20:50:39+00:00","insertUserID":56951,"insertUser":{"userID":56951,"name":"grantw","url":"https:\/\/community.smartsheet.com\/profile\/grantw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-06T12:10:27+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":false,"sink":false,"countComments":2,"countViews":56,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/30086\/trying-to-do-a-group-if-statment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30086\/trying-to-do-a-group-if-statment","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":30096,"type":"discussion","name":"Link if?","excerpt":"Hello! Is there a way to link cells, or even just copy cell\/row info, if a specific criteria is met? I am new to Smartsheet and haven't been able to find anything to do this. This is the situation: I am using a webform to create Purchase requests. I have approvals set up. Once the request has been APPROVED, I want specific…","categoryID":322,"dateInserted":"2018-08-06T13:53:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-06T17:08:53+00:00","insertUserID":56966,"insertUser":{"userID":56966,"name":"EmilyE","url":"https:\/\/community.smartsheet.com\/profile\/EmilyE","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-06-29T13:02:34+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":false,"sink":false,"countComments":2,"countViews":633,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/30096\/link-if","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30096\/link-if","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":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">