公式

50%) Note: also see that the % completed column is part of the Project Properties. ","categoryID":322,"dateInserted":"2019-01-03T14:59:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-03T15:09:56+00:00","insertUserID":74006,"insertUser":{"userID":74006,"name":"dinalu","url":"https:\/\/community.smartsheet.com\/profile\/dinalu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-03T14:57:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":62701,"lastUser":{"userID":62701,"name":"Brian W","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20W","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzUbwYJz-LmaGlMRoaP5WjQ9ZaP4MQ1PEwvjWez=s96-c","dateLastActive":"2022-03-18T16:10:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/38361\/count-rows-by-completed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38361\/count-rows-by-completed","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/98\/dc\/98dc63ddbb2084c9cfdf36f1570df741.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2019-01-03_14-58-44.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":36411,"type":"discussion","name":"Can you auto-replicate rows in a sheet based on a cell value?","excerpt":"We're putting together a Proof of Concept for our project management team. We're \"this close\" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way. Specifically,…","categoryID":322,"dateInserted":"2018-11-28T08:17:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-02T09:43:38+00:00","insertUserID":70166,"insertUser":{"userID":70166,"name":"mrsmorden","url":"https:\/\/community.smartsheet.com\/profile\/mrsmorden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-02T09:22:29+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":523,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/36411\/can-you-auto-replicate-rows-in-a-sheet-based-on-a-cell-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36411\/can-you-auto-replicate-rows-in-a-sheet-based-on-a-cell-value","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"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":38216,"type":"discussion","name":"Auto fill column?","excerpt":"Hi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula\/equation\/conditional formatting so that what's entered in one column will autofill another. Example: I have a column called Access Requested (dropdown) and another called Type of…","categoryID":322,"dateInserted":"2018-12-31T20:18:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-01T17:30:18+00:00","insertUserID":73706,"insertUser":{"userID":73706,"name":"SPalmieri","url":"https:\/\/community.smartsheet.com\/profile\/SPalmieri","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-04T18:39:34+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1347,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/38216\/auto-fill-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38216\/auto-fill-column","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":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":6177,"type":"discussion","name":"Calculating a day from a date","excerpt":"I've got a column (called \"Dates\") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), \"dddd\") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…","categoryID":318,"dateInserted":"2016-09-27T23:59:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-01T14:58:40+00:00","insertUserID":8493,"insertUser":{"userID":8493,"name":"Dajah","url":"https:\/\/community.smartsheet.com\/profile\/Dajah","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-10T15:09:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66316,"lastUser":{"userID":66316,"name":"MR","url":"https:\/\/community.smartsheet.com\/profile\/MR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Wv_UX3neUfw!!mBNQo2GzCYn","dateLastActive":"2020-07-09T09:53:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":1174,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6177\/calculating-a-day-from-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6177\/calculating-a-day-from-a-date","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}]},{"discussionID":38211,"type":"discussion","name":"Start & Finish dates based on separate predecessors \/ or formula in duration","excerpt":"I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…","categoryID":322,"dateInserted":"2018-12-31T13:53:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-01T08:07:20+00:00","insertUserID":63456,"insertUser":{"userID":63456,"name":"JamieRH","url":"https:\/\/community.smartsheet.com\/profile\/JamieRH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/b8\/d3\/nb8d344c976280621f5ad47ca88af2498.jpg","dateLastActive":"2019-07-25T09:54:37+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":180,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/38211\/start-finish-dates-based-on-separate-predecessors-or-formula-in-duration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38211\/start-finish-dates-based-on-separate-predecessors-or-formula-in-duration","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/4e\/a2\/4ea2538583759cd8d4ee672f36f29668.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":37936,"type":"discussion","name":"Returning a cell value if false","excerpt":"Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…","categoryID":322,"dateInserted":"2018-12-20T08:40:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-31T13:21:27+00:00","insertUserID":73186,"insertUser":{"userID":73186,"name":"artaylor","url":"https:\/\/community.smartsheet.com\/profile\/artaylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-17T10:07:30+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-11T12:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":747,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/37936\/returning-a-cell-value-if-false","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37936\/returning-a-cell-value-if-false","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/embarrassed_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"blush"},"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":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":36796,"type":"discussion","name":"Showing multiple true checkboxes as joined or concatenated text in another column","excerpt":"I have a volunteer submission form which has about 10 columns that exist as just checkboxes on\/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person\/row without tons of scrolling and looking up and down at column titles, I want to aggregate…","categoryID":322,"dateInserted":"2018-12-04T09:56:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-31T08:28:48+00:00","insertUserID":71171,"insertUser":{"userID":71171,"name":"KateP721","url":"https:\/\/community.smartsheet.com\/profile\/KateP721","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mSjB_srbMlY!xHFAcWLtIvo!0_HSWJRZuhn","dateLastActive":"2021-02-17T18:40:51+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":295,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/36796\/showing-multiple-true-checkboxes-as-joined-or-concatenated-text-in-another-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36796\/showing-multiple-true-checkboxes-as-joined-or-concatenated-text-in-another-column","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":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":249,"urlcode":"Education","name":"Education"},{"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":36896,"type":"discussion","name":"ISdate or ISblank","excerpt":"I'm trying to achive this: Field Maintenance: If my field Last maintenance date is empty, i need to put today's date, if there's a date i need to put Last maintenance date + Frequency (day) Not able to make it works with isblank or isdate, any other idea? thanks","categoryID":322,"dateInserted":"2018-12-05T11:59:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-31T08:26:23+00:00","insertUserID":69571,"insertUser":{"userID":69571,"name":"davidv","url":"https:\/\/community.smartsheet.com\/profile\/davidv","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-05T11:52:47+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":229,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/36896\/isdate-or-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36896\/isdate-or-isblank","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":37001,"type":"discussion","name":"Conditional Formatting","excerpt":"Hi I am hoping someone might have a simpler solution than the one I am thinking of. I am creating a sheet for my company to track all of our projects. The scope of what we do for each project varies based on what kind of campaign it is. There are 10 different kinds of campaigns, so say for example Campaign Type A might…","categoryID":322,"dateInserted":"2018-12-06T12:56:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-31T08:22:37+00:00","insertUserID":22626,"insertUser":{"userID":22626,"name":"Brian Kluger","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Kluger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-05T15:04:02+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":57,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/37001\/conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37001\/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"}],"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":36556,"type":"discussion","name":"Linking Sheets","excerpt":"I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?","categoryID":322,"dateInserted":"2018-11-29T12:27:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-31T08:10:07+00:00","insertUserID":70671,"insertUser":{"userID":70671,"name":"Nadine_bn","url":"https:\/\/community.smartsheet.com\/profile\/Nadine_bn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-25T08:56:52+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-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":213,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/36556\/linking-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36556\/linking-sheets","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"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}">