Marketing

\"0\", [% complete]1 <= \"0.25\"), \"Quarter\", IF(OR([% complete]1 > \"0.25\", [% complete]1 <= \"0.5\"), \"Half\", IF(OR([% complete]1 >…","categoryID":322,"dateInserted":"2019-11-01T10:48:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-01T17:14:58+00:00","insertUserID":109661,"insertUser":{"userID":109661,"name":"Alessandro Terranova","url":"https:\/\/community.smartsheet.com\/profile\/Alessandro%20Terranova","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-18T09:32:12+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-07-06T18:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":132,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/61756\/if-or-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61756\/if-or-formula-help","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"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"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":3869,"type":"discussion","name":"Selecting Multiple Values from a Dropdown List","excerpt":"I have created a \"dropdown list\" column and added the values. I want to be able to select multiple values from the list. How do I do that? Thanks, Judith","categoryID":318,"dateInserted":"2016-01-06T15:47:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-29T11:41:51+00:00","insertUserID":4858,"insertUser":{"userID":4858,"name":"Judith Soto","url":"https:\/\/community.smartsheet.com\/profile\/Judith%20Soto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-06T15:43:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":109251,"lastUser":{"userID":109251,"name":"Cindy Van den Bremt","url":"https:\/\/community.smartsheet.com\/profile\/Cindy%20Van%20den%20Bremt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!5sDMeWjafWQ!gTlPoKS0ELo!ZYqBXPhLvVv","dateLastActive":"2021-12-03T19:36:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":18,"countViews":233,"score":null,"hot":18,"url":"https:\/\/community.smartsheet.com\/discussion\/3869\/selecting-multiple-values-from-a-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3869\/selecting-multiple-values-from-a-dropdown-list","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":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":61216,"type":"discussion","name":"Content Approval Template","excerpt":"Hi Guys, Have us used a template that works well for you? Please share","categoryID":321,"dateInserted":"2019-10-25T08:59:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-25T09:25:44+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-07-11T16:01:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":171,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/61216\/content-approval-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61216\/content-approval-template","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"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":60871,"type":"discussion","name":"Dashboard Permissions to Report\/Data","excerpt":"I have created a dashboard for our creative team that is set up so that only the person viewing the dashboard can see their metrics. That being said, I found out the hard way that they cannot see their data unless I share them out to the metrics sheet and the metrics report. Is there any way to avoid this? I don't…","categoryID":321,"dateInserted":"2019-10-21T15:40:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-23T10:30:31+00:00","insertUserID":66016,"insertUser":{"userID":66016,"name":"BTMarketingOps","url":"https:\/\/community.smartsheet.com\/profile\/BTMarketingOps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T19:39:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/60871\/dashboard-permissions-to-report-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60871\/dashboard-permissions-to-report-data","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"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":60396,"type":"discussion","name":"SUMIF(OR(???","excerpt":"I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half…","categoryID":322,"dateInserted":"2019-10-16T14:18:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-16T14:45:08+00:00","insertUserID":107836,"insertUser":{"userID":107836,"name":"KaitlinH2","url":"https:\/\/community.smartsheet.com\/profile\/KaitlinH2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pAjAKaoEpyY!-njBt2rwEiY!veQ521AAkcg","dateLastActive":"2022-02-02T15:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":107836,"lastUser":{"userID":107836,"name":"KaitlinH2","url":"https:\/\/community.smartsheet.com\/profile\/KaitlinH2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pAjAKaoEpyY!-njBt2rwEiY!veQ521AAkcg","dateLastActive":"2022-02-02T15:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":314,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/60396\/sumif-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60396\/sumif-or","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":266,"urlcode":"Real Estate","name":"Real Estate"},{"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":59826,"type":"discussion","name":"Dynamic SmartSheets an Option?","excerpt":"First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…","categoryID":321,"dateInserted":"2019-10-09T14:58:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-15T05:54:08+00:00","insertUserID":107041,"insertUser":{"userID":107041,"name":"Jen Burnett","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20Burnett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/9d\/72\/n9d72174fe2b8820a2225585659ae95aa.jpg","dateLastActive":"2020-05-15T17:52:10+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-07-11T16:01:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":191,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/59826\/dynamic-smartsheets-an-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59826\/dynamic-smartsheets-an-option","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"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":60086,"type":"discussion","name":"Set up Review Request button grayed out in proofing","excerpt":"I'm giving the new proofing tool a try, and am stuck. I've enabled proofing on a sheet that I created in a workspace with numerous users with different levels of permissions, and have uploaded and made a couple pinned notations on an image (I have not yet @mentioned anyone). However, the button for Set up Review Request is…","categoryID":321,"dateInserted":"2019-10-12T12:48:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-14T18:38:49+00:00","insertUserID":1240,"insertUser":{"userID":1240,"name":"Deirdre Spencer","url":"https:\/\/community.smartsheet.com\/profile\/Deirdre%20Spencer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/8d\/2a\/n8d2a6ba8bcca452cd28465fa0eda1d66.jpg","dateLastActive":"2020-12-23T18:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":1240,"lastUser":{"userID":1240,"name":"Deirdre Spencer","url":"https:\/\/community.smartsheet.com\/profile\/Deirdre%20Spencer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/8d\/2a\/n8d2a6ba8bcca452cd28465fa0eda1d66.jpg","dateLastActive":"2020-12-23T18:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":378,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/60086\/set-up-review-request-button-grayed-out-in-proofing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60086\/set-up-review-request-button-grayed-out-in-proofing","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/0c\/71\/0c71bceee94a0ebaf84db3594382fd92.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2019-10-13 at 11.39.02 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"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}">