政府

=DATE(2018, 4, 1)) Next I'd like to add…","categoryID":322,"dateInserted":"2018-07-24T17:24:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-05-11T12:09:33+00:00","insertUserID":55506,"insertUser":{"userID":55506,"name":"jjimenez55506","url":"https:\/\/community.smartsheet.com\/profile\/jjimenez55506","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-24T17:09:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147092,"lastUser":{"userID":147092,"name":"WendyR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/WendyR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xykmMbfF4Ds!!KgvfOaf6by-","dateLastActive":"2022-05-16T12:04:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":39,"countViews":4141,"score":null,"hot":39,"url":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","format":"Html","groupID":null,"statusID":8,"image":{"url":"\/libraries\/smiley\/images\/regular_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"smiley"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":62916,"type":"discussion","name":"ODBC Connection with Visio","excerpt":"Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our \"reports to\" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…","categoryID":343,"dateInserted":"2019-11-14T13:07:35+00:00","dateUpdated":"2022-06-14T14:36:36+00:00","dateLastComment":"2022-05-05T15:07:48+00:00","insertUserID":111291,"insertUser":{"userID":111291,"name":"C_Carroll","url":"https:\/\/community.smartsheet.com\/profile\/C_Carroll","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-14T13:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":91566,"lastUserID":121187,"lastUser":{"userID":121187,"name":"C. Powell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/C.%20Powell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!w5Vbd8G-A6Q!5RFbOeXmb3o!5B7zbp4zJ4Z","dateLastActive":"2022-06-10T17:54:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":266,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/62916\/odbc-connection-with-visio","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62916\/odbc-connection-with-visio","format":"Html","groupID":null,"statusID":8,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/7a\/0c\/7a0cdf919aa52aebea251cbfb0f392bd.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"ODBC compliant data source.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":90617,"type":"question","name":"Changing the default Timeline Display for Gantt Charts?","excerpt":"Hi there, Is it possible to change the default Timeline Display options for Gantt Charts (whether in Sheets or Reports, or ideally differently for each) such that when a new user views them for the first time they see the settings that the author intended? Right now, if I set these options for my own view of Gantt Charts…","categoryID":321,"dateInserted":"2022-04-28T23:07:40+00:00","dateUpdated":null,"dateLastComment":"2022-05-04T09:15:03+00:00","insertUserID":120919,"insertUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-11T23:37:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120501,"lastUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-15T18:03:50+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":33,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/90617\/changing-the-default-timeline-display-for-gantt-charts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90617\/changing-the-default-timeline-display-for-gantt-charts","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WXEG65AZA396\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-04T09:15:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":70460,"type":"question","name":"Hide comments in a published report?","excerpt":"Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as \"Read only - HTML\", but this option does not appear to be available when publishing a report. There are comments in our main sheet that the report is built on which we do not want to be visible in the…","categoryID":321,"dateInserted":"2020-08-07T18:14:49+00:00","dateUpdated":"2020-08-07T18:16:20+00:00","dateLastComment":"2022-04-29T16:52:01+00:00","insertUserID":120919,"insertUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-11T23:37:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":120919,"lastUserID":147162,"lastUser":{"userID":147162,"name":"kerobi","url":"https:\/\/community.smartsheet.com\/profile\/kerobi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-29T16:50:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":777,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/70460\/hide-comments-in-a-published-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70460\/hide-comments-in-a-published-report","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-08-11T21:09:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":301,"urlcode":"Comments and Conversations","name":"Comments and Conversations"}],"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":21646,"type":"discussion","name":"What's with the \"unnamed series\" in the pie chart?","excerpt":"So I've created a pie chart in my Dashboard and let's say I have basic data such as: Apples 5 Oranges 12 Bananas 8 Blueberries 20 Strawberries 3 Rasberries 19 With this data, when I tried to import it as shown above, it gave me an error. When I imported only the values\/numbers, it worked. However, now I cannot show which…","categoryID":321,"dateInserted":"2018-03-19T12:07:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-04-25T10:53:42+00:00","insertUserID":38121,"insertUser":{"userID":38121,"name":"QueenD","url":"https:\/\/community.smartsheet.com\/profile\/QueenD","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-18T11:35:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-18T14:52:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":1069,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/21646\/whats-with-the-unnamed-series-in-the-pie-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/21646\/whats-with-the-unnamed-series-in-the-pie-chart","format":"Html","groupID":null,"statusID":8,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/c5\/90\/c5909aa696f354384278767a8191b788.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Smartsheet Pie Chart.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":90373,"type":"question","name":"Centering Gantt chart bars vertical alignment?","excerpt":"Is it possible to \"center\" the \"vertical\" alignment of the bars on a Gantt chart (in a Report, but also in a Sheet)? The default seems to be that they appear at the top of their row, but I'd like them to appear in the middle so that they line up with the rest of the (vertically centered) text in the row. I feel like I've…","categoryID":321,"dateInserted":"2022-04-22T15:47:07+00:00","dateUpdated":null,"dateLastComment":"2022-04-23T08:52:44+00:00","insertUserID":120919,"insertUser":{"userID":120919,"name":"Jamie Bedford","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Bedford","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-11T23:37:44+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-06-19T00:11:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/90373\/centering-gantt-chart-bars-vertical-alignment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90373\/centering-gantt-chart-bars-vertical-alignment","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/OZDAHFAWOBJP\/smartsheet-community-question-gantt-vertical-alignment.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"smartsheet community question - gantt vertical alignment.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-04-28T23:08:21+00:00","dateAnswered":"2022-04-23T08:52:44+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":50621,"type":"discussion","name":"Automation Trigger \"When Rows are Changed\" not working","excerpt":"I have been banging my head on this. I need to set up a very simple trigger that when a cell is updated, a notification is sent about that row. I am using the \"When Rows are Changed\" trigger and defining my cell condition, and filters. I have also tried the \"When Rows are added or changed\" trigger with no success. I have…","categoryID":321,"dateInserted":"2019-06-13T16:20:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-01-31T13:59:13+00:00","insertUserID":92206,"insertUser":{"userID":92206,"name":"DevinD","url":"https:\/\/community.smartsheet.com\/profile\/DevinD","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-18T16:27:04+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":144312,"lastUser":{"userID":144312,"name":"Lori Martin","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-15T17:20:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":2283,"score":null,"hot":15,"url":"https:\/\/community.smartsheet.com\/discussion\/50621\/automation-trigger-when-rows-are-changed-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50621\/automation-trigger-when-rows-are-changed-not-working","format":"Html","groupID":null,"statusID":8,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-06\/15\/02\/1502e068ede1a9b606890055a6f50280.gif","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"pic.gif"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":263,"urlcode":"Government","name":"Government"},{"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":43936,"type":"discussion","name":"Time Tracking - Hours and Minutes","excerpt":"I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put \"00\" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…","categoryID":322,"dateInserted":"2019-03-19T12:45:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-11-02T17:35:29+00:00","insertUserID":58936,"insertUser":{"userID":58936,"name":"Ezra","url":"https:\/\/community.smartsheet.com\/profile\/Ezra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/722\/n8VN7BXAAHKNJ.png","dateLastActive":"2020-07-17T14:29:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-17T20:25:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1617,"score":1,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/43936\/time-tracking-hours-and-minutes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43936\/time-tracking-hours-and-minutes","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":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":236,"urlcode":"Metals & Mining","name":"Metals & Mining"},{"tagID":237,"urlcode":"Transportation","name":"Transportation"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":242,"urlcode":"Resource Views","name":"Resource Views"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":262,"urlcode":"Agriculture","name":"Agriculture"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":264,"urlcode":"Financial Services","name":"Financial Services"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":267,"urlcode":"Energy & Utilities","name":"Energy & Utilities"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":276,"urlcode":"Retail","name":"Retail"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":84395,"type":"question","name":"Using IF and CONTAINS in one formula","excerpt":"I am trying to create a formula that returns: Tolerable if the answer is Low Tolerable if the answer is Medium Acceptable if the answer is High Acceptible if the answer contains Urgent. I need to figure out how to use \"CONTAINS\" because some answers have dashes and other things that mess up the formulas. =IF(Answer@row =…","categoryID":322,"dateInserted":"2021-10-26T15:51:57+00:00","dateUpdated":null,"dateLastComment":"2021-10-26T16:16:40+00:00","insertUserID":141235,"insertUser":{"userID":141235,"name":"Jess Trial","url":"https:\/\/community.smartsheet.com\/profile\/Jess%20Trial","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pPFCqTUjpvw!!yS3u1acMk34","dateLastActive":"2022-04-27T12:33:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":140911,"lastUser":{"userID":140911,"name":"USB Mike","url":"https:\/\/community.smartsheet.com\/profile\/USB%20Mike","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-12-08T18:08:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84395\/using-if-and-contains-in-one-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84395\/using-if-and-contains-in-one-formula","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/205IL05EVA2U\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-10-26T16:37:32+00:00","dateAnswered":"2021-10-26T16:16:40+00:00","acceptedAnswers":[]}},"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":263,"urlcode":"Government","name":"Government"}],"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":64571,"type":"discussion","name":"Dashboard access via link not showing the user as logged in.","excerpt":"So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works perfectly and they are able to view it. However, when they use the published link (which…","categoryID":321,"dateInserted":"2019-12-05T13:54:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-10-21T19:40:48+00:00","insertUserID":17836,"insertUser":{"userID":17836,"name":"Shesha_K","url":"https:\/\/community.smartsheet.com\/profile\/Shesha_K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/55\/a6\/n55a6a4afb04f11891cef2abdcc8143ba.jpg","dateLastActive":"2022-06-14T18:55:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-18T14:52:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":175,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/64571\/dashboard-access-via-link-not-showing-the-user-as-logged-in","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64571\/dashboard-access-via-link-not-showing-the-user-as-logged-in","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":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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}">