Marketing

0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :) ","categoryID":322,"dateInserted":"2019-02-05T06:19:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-23T11:00:36+00:00","insertUserID":41351,"insertUser":{"userID":41351,"name":"Anna Mullins","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Mullins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/c6\/0e\/nc60eae9be62b12eb53439135e60f2271.PNG","dateLastActive":"2019-02-05T15:25:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T07:28:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":275,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ee\/fb\/eefb428415c3eeb9aaf289881d0445e1.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula.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":207,"urlcode":"Sales","name":"Sales"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":264,"urlcode":"Financial Services","name":"Financial Services"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":302,"urlcode":"Community Platform","name":"Community Platform"}],"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":61631,"type":"discussion","name":"Dashboard Widget Chart Issue with Multi Select","excerpt":"I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…","categoryID":322,"dateInserted":"2019-10-30T17:59:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-08T14:06:48+00:00","insertUserID":108746,"insertUser":{"userID":108746,"name":"Samira","url":"https:\/\/community.smartsheet.com\/profile\/Samira","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zateM4QT1Po!7LjduygCTCQ!kj9JKzSxn0n","dateLastActive":"2021-05-21T16:22:07+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":"2022-09-01T20:14:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":688,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/61631\/dashboard-widget-chart-issue-with-multi-select","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61631\/dashboard-widget-chart-issue-with-multi-select","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"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":55901,"type":"discussion","name":"Method to limit attachment types?","excerpt":"I have a form that is designed for employees to submit news stories for our website to which they are also allowed to upload an image to accompany the story. My problem is that, despite specific instructions NOT to do so, employees often provide their images embedded in Word docs, PPTX files, PDFs, even ZIPs. I need them…","categoryID":321,"dateInserted":"2019-08-22T11:25:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-03-11T08:41:56+00:00","insertUserID":3542,"insertUser":{"userID":3542,"name":"Dan Snodgrass","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Snodgrass","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nPYG63XB2DF2E.png","dateLastActive":"2020-10-28T13:42:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-04T07:28:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":182,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/55901\/method-to-limit-attachment-types","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55901\/method-to-limit-attachment-types","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"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":64121,"type":"discussion","name":"Proofing Review Request","excerpt":"Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the \"Set up Review Request\"? We have some people who are admins and some who are not who would use proofing. I want to make sure anyone can send out a review request, but wasn't…","categoryID":321,"dateInserted":"2019-11-29T09:34:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-01-30T04:47:17+00:00","insertUserID":103356,"insertUser":{"userID":103356,"name":"Astazio","url":"https:\/\/community.smartsheet.com\/profile\/Astazio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/be\/4a\/nbe4ac0676ece2e3f377850fa0215039d.jpeg","dateLastActive":"2022-07-19T10:26:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":117703,"lastUser":{"userID":117703,"name":"Bradley Durham","url":"https:\/\/community.smartsheet.com\/profile\/Bradley%20Durham","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-30T21:24:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":76,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/64121\/proofing-review-request","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64121\/proofing-review-request","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":228,"urlcode":"Project Management","name":"Project Management"},{"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}">