公式

讨论表

\"\"),A1:D1),EOMONTH(LOOKUP(2,1\/(A1:D1<>\"\"),A1:D1),3)) This formula does not translate to smartsheet. I need a formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month. ","categoryID":322,"dateInserted":"2018-01-25T15:42:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T09:11:39+00:00","insertUserID":35786,"insertUser":{"userID":35786,"name":"Jeeppler","url":"https:\/\/community.smartsheet.com\/profile\/Jeeppler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-29T08:50:17+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-13T15:13:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":165,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18411\/formula-to-auto-fill-date-based-on-last-non-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18411\/formula-to-auto-fill-date-based-on-last-non-blank","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":18441,"type":"discussion","name":"Conditional sum formula","excerpt":"Please be gentle, very novice smartsheet user! I am trying to get a total value on a smart sheet when certain conditions are met. I have a column called Type and a column called value, so when cell entries in column type are a particular value, I want a sum of the values recorded against that type in column value. And I…","categoryID":322,"dateInserted":"2018-01-26T06:40:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-26T08:49:08+00:00","insertUserID":19846,"insertUser":{"userID":19846,"name":"Ian Smith 2017","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Smith%202017","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-22T12:42:17+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-15T10:24:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":619,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18441\/conditional-sum-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18441\/conditional-sum-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":7362,"type":"discussion","name":"AND + NOT isblank","excerpt":"Trying to produce a formula which says if X is blank and Y is not blank, then check. =IF(AND([Eval Cost]1 = \"\", (NOT([Client]1=\"\"), 1,0) Thanks","categoryID":319,"dateInserted":"2017-02-19T15:20:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-25T19:01:01+00:00","insertUserID":10897,"insertUser":{"userID":10897,"name":"Joshua Rose","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-18T23:57:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5931,"lastUser":{"userID":5931,"name":"Morri Young","url":"https:\/\/community.smartsheet.com\/profile\/Morri%20Young","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/82\/8a\/n828a9313312474364fff3403076fabab.jpg","dateLastActive":"2018-02-09T17:56:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":13,"countViews":2574,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/7362\/and-not-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7362\/and-not-isblank","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":18421,"type":"discussion","name":"Help with If ISBLANK or statement","excerpt":"I'd like a column to populate \"late\" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?","categoryID":322,"dateInserted":"2018-01-25T16:38:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-25T17:52:21+00:00","insertUserID":35801,"insertUser":{"userID":35801,"name":"faganc","url":"https:\/\/community.smartsheet.com\/profile\/faganc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-26T11:53:48+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-06-13T17:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":170,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/18421\/help-with-if-isblank-or-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18421\/help-with-if-isblank-or-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":238,"urlcode":"Finance","name":"Finance"},{"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":18366,"type":"discussion","name":"Conditional formatting","excerpt":"Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?","categoryID":322,"dateInserted":"2018-01-25T09:24:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-25T11:46:20+00:00","insertUserID":35541,"insertUser":{"userID":35541,"name":"agetchius35541","url":"https:\/\/community.smartsheet.com\/profile\/agetchius35541","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-24T08:10:59+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-06-13T17:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":210,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/18366\/conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18366\/conditional-formatting","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":281,"urlcode":"Support","name":"Support"},{"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":18141,"type":"discussion","name":"Adding Nested IF Statement to Formula","excerpt":"I have a formula that calculates the \"Planned % Complete\" based on start and end date, with no weighting. We use it as a general guide because there is no planned % complete provided by Smartsheet. Formula: =IF(Start14 >= TODAY(), 0, IF(Finish14<= TODAY(), 1, (NETWORKDAY(Start14, MIN(TODAY(), Finish14)) \/…","categoryID":322,"dateInserted":"2018-01-21T19:34:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-25T11:18:25+00:00","insertUserID":21506,"insertUser":{"userID":21506,"name":"MelG","url":"https:\/\/community.smartsheet.com\/profile\/MelG","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-19T03:27:15+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":false,"sink":false,"countComments":1,"countViews":288,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/18141\/adding-nested-if-statement-to-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18141\/adding-nested-if-statement-to-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":18331,"type":"discussion","name":"Reporting Earned Value vs Planned Value for SPI Metrics","excerpt":"Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start\/end dates, duration, dependencies, and % complete. We do not resource…","categoryID":322,"dateInserted":"2018-01-24T15:35:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-25T09:26:04+00:00","insertUserID":35606,"insertUser":{"userID":35606,"name":"PM_Mr Bill","url":"https:\/\/community.smartsheet.com\/profile\/PM_Mr%20Bill","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-24T15:21:53+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-13T15:13:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":697,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18331\/reporting-earned-value-vs-planned-value-for-spi-metrics","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18331\/reporting-earned-value-vs-planned-value-for-spi-metrics","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":8851,"type":"discussion","name":"Formula for calculating years accurately","excerpt":"We need a formula for calculating years accurately when we compare a date with the date today – some examples would be: * Age in years: Today() - date of birth, currently we use: =(TODAY() – DOB1) \/ 365.25 but it doesn’t always give the correct answer. The 365.25 is days in a year allowing for leap years, or * Length of…","categoryID":319,"dateInserted":"2017-05-02T18:44:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-24T17:14:03+00:00","insertUserID":323,"insertUser":{"userID":323,"name":"StephenLake","url":"https:\/\/community.smartsheet.com\/profile\/StephenLake","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w69PP1S1h3o!BWjMQcjaLFQ!oFT8pEzEIfU","dateLastActive":"2023-04-13T22:37:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":787,"lastUser":{"userID":787,"name":"Meritza Webb","url":"https:\/\/community.smartsheet.com\/profile\/Meritza%20Webb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZtMoZTY8no!7BFPu3S2R_o!MTfdCnvwkyU","dateLastActive":"2021-01-21T18:45:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":2559,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/8851\/formula-for-calculating-years-accurately","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/8851\/formula-for-calculating-years-accurately","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":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":18231,"type":"discussion","name":"Newbie: trying to return cell contents if date is less than and greater than...","excerpt":"I'm new at this. Let's say these are my three columns: Open Balance | AR Due Date | WK 1 So in the WK1 cell I want this formula: If the AR Due Date is greater than 01\/01\/2018 and less than 01\/07\/2018, then return the value of Open Balance. I've tried, but keep getting errors. Thanks for your help. ","categoryID":322,"dateInserted":"2018-01-23T11:13:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-01-24T10:07:04+00:00","insertUserID":35466,"insertUser":{"userID":35466,"name":"DV","url":"https:\/\/community.smartsheet.com\/profile\/DV","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-06T12:00:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":35466,"lastUser":{"userID":35466,"name":"DV","url":"https:\/\/community.smartsheet.com\/profile\/DV","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-06T12:00:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":2403,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/18231\/newbie-trying-to-return-cell-contents-if-date-is-less-than-and-greater-than","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18231\/newbie-trying-to-return-cell-contents-if-date-is-less-than-and-greater-than","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">