讨论
18), OR({Current Jobs Created Hour}, <7, {Current Jobs Created Hour}, >18),…","categoryID":322,"dateInserted":"2019-04-01T14:54:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T07:54:37+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":82,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/44791\/countifs-formula-including-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44791\/countifs-formula-including-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"}],"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":32591,"type":"discussion","name":"ROUND Function - Round up to nearest whole number","excerpt":"Hello, I want to be able to round up a number to the nearest whole - for example 4.1 would round to 5, 4 would stay as 4 5.6 would round to 6. any whole numbers would not round but stay the same.","categoryID":321,"dateInserted":"2018-09-25T21:42:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-10-22T20:57:02+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6874,"lastUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":2729,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/32591\/round-function-round-up-to-nearest-whole-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/32591\/round-function-round-up-to-nearest-whole-number","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":[],"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":25796,"type":"discussion","name":"email data from smartsheet nice visuals","excerpt":"Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible","categoryID":320,"dateInserted":"2018-05-22T17:48:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-22T19:01:04+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":212,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25796\/email-data-from-smartsheet-nice-visuals","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25796\/email-data-from-smartsheet-nice-visuals","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"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":21671,"type":"discussion","name":"Sending Reports Automatically via Email with a dynamic contact list","excerpt":"We send out 100's of reports to customers monthly and have these set up at the time we set up a report. Our problem is our customer email addresses change often, which means we have to re set-up the report email to be sent to the new email address. Is there anyway to make this dynamic - ie the report looks up another…","categoryID":321,"dateInserted":"2018-03-19T17:40:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-20T05:00:51+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-08-07T12:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":102,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/21671\/sending-reports-automatically-via-email-with-a-dynamic-contact-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/21671\/sending-reports-automatically-via-email-with-a-dynamic-contact-list","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":[],"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":19486,"type":"discussion","name":"Dependent dropdowns using Smartsheet Sync & Google","excerpt":"Hello, does anyone know is it possible to create a google form and link it to an existing smartsheet rather than create a new smartsheet??","categoryID":343,"dateInserted":"2018-02-13T19:11:03+00:00","dateUpdated":"2022-06-14T14:36:04+00:00","dateLastComment":"2018-02-14T03:14:53+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":204,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/19486\/dependent-dropdowns-using-smartsheet-sync-google","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19486\/dependent-dropdowns-using-smartsheet-sync-google","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"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":10336,"type":"discussion","name":"Date checkbox formula","excerpt":"Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…","categoryID":319,"dateInserted":"2017-06-14T20:55:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-06-16T16:53:23+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":145,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/10336\/date-checkbox-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/10336\/date-checkbox-formula","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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":7862,"type":"discussion","name":"Complicated formula help","excerpt":"Hello, I want to create a formula that changes the unit price to half price when the quanitity goes above a certain amount - ie. Columns [Quantity], [Unitprice], [Total] - I want to charge the normal unit price for up to a quanitty of 24, when the quantity is over 24, then I want the quantity that is over and above 24 to…","categoryID":319,"dateInserted":"2017-04-04T18:11:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-04-04T22:14:54+00:00","insertUserID":6874,"insertUser":{"userID":6874,"name":"LouSnz","url":"https:\/\/community.smartsheet.com\/profile\/LouSnz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-08T17:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6199,"lastUser":{"userID":6199,"name":"Rob Hagan","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Hagan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5a\/36\/n5a3670842ff6152dc89438b8153da7c0.jpg","dateLastActive":"2022-12-06T19:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":12,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/7862\/complicated-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7862\/complicated-formula-help","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":[],"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":false,"noCheckboxes":true}">
