市场营销

0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…","categoryID":318,"dateInserted":"2016-09-26T01:45:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-26T17:47:48+00:00","insertUserID":8452,"insertUser":{"userID":8452,"name":"Matthew Anthon","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20Anthon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-08T19:01:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8452,"lastUser":{"userID":8452,"name":"Matthew Anthon","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20Anthon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-08T19:01:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":12655,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6153\/using-and-and-isblank-in-nested-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6153\/using-and-and-isblank-in-nested-if-statement","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":207,"urlcode":"Sales","name":"Sales"},{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":5910,"type":"discussion","name":"Card view - spanning lanes","excerpt":"Hi Is it possible to have some fields in the card view span several lanes? Thanks, Galit","categoryID":318,"dateInserted":"2016-08-25T05:19:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-13T15:49:20+00:00","insertUserID":8073,"insertUser":{"userID":8073,"name":"Galit","url":"https:\/\/community.smartsheet.com\/profile\/Galit","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-20T10:34:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":554,"lastUser":{"userID":554,"name":"Ryan Woodruff","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Woodruff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-13T15:46:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5910\/card-view-spanning-lanes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5910\/card-view-spanning-lanes","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":270,"urlcode":"Technology","name":"Technology"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":299,"urlcode":"Card View","name":"Card View"}],"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":5948,"type":"discussion","name":"Simple email capability?","excerpt":"is there any way to load an email address into a smartsheet cell and then send an email to that address simply by clicking on it?","categoryID":318,"dateInserted":"2016-08-29T18:55:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-29T20:41:30+00:00","insertUserID":8126,"insertUser":{"userID":8126,"name":"Jerry Vieira","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Vieira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-29T18:53:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":7721,"lastUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":33,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5948\/simple-email-capability","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5948\/simple-email-capability","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":270,"urlcode":"Technology","name":"Technology"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"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":4662,"type":"discussion","name":"Conditional Formatting on Parent Line","excerpt":"I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.","categoryID":318,"dateInserted":"2016-04-05T16:38:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-18T14:58:08+00:00","insertUserID":6134,"insertUser":{"userID":6134,"name":"Lindsey Treulieb","url":"https:\/\/community.smartsheet.com\/profile\/Lindsey%20Treulieb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-05T16:35:43+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":318,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/4662\/conditional-formatting-on-parent-line","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4662\/conditional-formatting-on-parent-line","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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":5660,"type":"discussion","name":"Excel spreadsheet with calendar and schedule","excerpt":"Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…","categoryID":318,"dateInserted":"2016-07-29T17:07:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-08T02:00:04+00:00","insertUserID":7089,"insertUser":{"userID":7089,"name":"Jacob S","url":"https:\/\/community.smartsheet.com\/profile\/Jacob%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-06T13:33:51+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":"2022-10-25T19:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":102,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5660\/excel-spreadsheet-with-calendar-and-schedule","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5660\/excel-spreadsheet-with-calendar-and-schedule","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":5700,"type":"discussion","name":"Conditional Symbols $ to $$$$$","excerpt":"Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), \"One\", IF(Saving1 = MAX(Saving:Saving), \"Five\", IF(Saving1 = AVG(Saving:Saving), \"Three\", IF(Saving1…","categoryID":318,"dateInserted":"2016-08-05T00:50:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-05T11:14:44+00:00","insertUserID":4900,"insertUser":{"userID":4900,"name":"Christian Wells","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20Wells","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/cd\/21\/ncd21ac3b27c042921669a4a042840ca4.jpg","dateLastActive":"2021-04-14T05:25:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5700\/conditional-symbols-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5700\/conditional-symbols-to","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/community.smartsheet.com\/sites\/all\/libraries\/tinymce\/jscripts\/tiny_mce\/plugins\/emotions\/img\/smiley-smile.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smile"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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}">