存档的2015个帖子
讨论表
0% AND < 100%, then…","categoryID":317,"dateInserted":"2015-10-01T11:51:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-10T08:13:03+00:00","insertUserID":3620,"insertUser":{"userID":3620,"name":"Diego","url":"https:\/\/community.smartsheet.com\/profile\/Diego","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-10-01T11:47:22+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":87911,"lastUser":{"userID":87911,"name":"latsyrcg3","url":"https:\/\/community.smartsheet.com\/profile\/latsyrcg3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-20T17:31:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":4407,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/2322\/update-a-status-column-when-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2322\/update-a-status-column-when-complete","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":107,"type":"discussion","name":"Hiding Completed tasks","excerpt":"I'm using smartsheet to track projects and their coresponding action items. After tasks are completed, I want to be able hide the rows to make the smartsheet easier to navigate. Is it possible to hide rows? I can't tfind the functionality. Any help would be appreciated.","categoryID":317,"dateInserted":"2015-04-13T12:11:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-09T15:20:40+00:00","insertUserID":755,"insertUser":{"userID":755,"name":"Rich Godberg","url":"https:\/\/community.smartsheet.com\/profile\/Rich%20Godberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-13T12:04:03+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":87911,"lastUser":{"userID":87911,"name":"latsyrcg3","url":"https:\/\/community.smartsheet.com\/profile\/latsyrcg3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-20T17:31:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":10,"countViews":4472,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/107\/hiding-completed-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107\/hiding-completed-tasks","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":249,"urlcode":"Education","name":"Education"}],"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":391,"type":"discussion","name":"Drop down list data from column in another sheet","excerpt":"Hello Users, I am very new to SS and was wondering how I might go about achieving the ability to link a cells data to an entire column in another sheet. For example, I have a \"Current Jobs\" sheet and a \"Distributors\" sheet. When I enter a new job in Current Jobs, the Distributor field in current jobs must only contain…","categoryID":317,"dateInserted":"2015-05-27T22:18:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-08T08:10:21+00:00","insertUserID":1995,"insertUser":{"userID":1995,"name":"Nayshil","url":"https:\/\/community.smartsheet.com\/profile\/Nayshil","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-05-27T22:06:17+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":"2022-05-26T10:59:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":93,"countViews":7918,"score":null,"hot":93,"url":"https:\/\/community.smartsheet.com\/discussion\/391\/drop-down-list-data-from-column-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/391\/drop-down-list-data-from-column-in-another-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"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":597,"type":"discussion","name":"Gantt Chart Zoom","excerpt":"When I am viewing and printing gantt charts I often need a zoom level in between the default zoom levels available for gantt charts. Is it possible to incorporate more felxibility with how zoomed in or out a gantt chart is? Maybe a slider or number?","categoryID":317,"dateInserted":"2015-06-24T13:13:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-04T20:43:21+00:00","insertUserID":2257,"insertUser":{"userID":2257,"name":"Dusty Robinson","url":"https:\/\/community.smartsheet.com\/profile\/Dusty%20Robinson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/03\/2c\/n032c7f6510420fa30ffec56357a400e2.jpg","dateLastActive":"2021-09-28T19:20:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":106501,"lastUser":{"userID":106501,"name":"TPFS","url":"https:\/\/community.smartsheet.com\/profile\/TPFS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-04T20:40:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":22,"countViews":1156,"score":null,"hot":22,"url":"https:\/\/community.smartsheet.com\/discussion\/597\/gantt-chart-zoom","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/597\/gantt-chart-zoom","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":250,"urlcode":"Printing","name":"Printing"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt 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":290,"type":"discussion","name":"Sum of a Cell Range, Dependent on a Dropdown Value","excerpt":"Is there a way to add up the total of a cell, dependent on the drop down value of the row? For instance... I would like to total the sum of the revnue (shown in the \"Live Revenue Log\") by the day (shown in the \"Daily Revenue Overview\") ","categoryID":317,"dateInserted":"2015-05-12T10:36:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-02T18:44:00+00:00","insertUserID":1812,"insertUser":{"userID":1812,"name":"BrentonJohn","url":"https:\/\/community.smartsheet.com\/profile\/BrentonJohn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-02T14:32:58+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":76161,"lastUser":{"userID":76161,"name":"kapears76161","url":"https:\/\/community.smartsheet.com\/profile\/kapears76161","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-05\/56\/53\/n5653efd44f2979ca7fe78668f38a2b6f.jpg","dateLastActive":"2021-06-22T17:51:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":4957,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/290\/sum-of-a-cell-range-dependent-on-a-dropdown-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/290\/sum-of-a-cell-range-dependent-on-a-dropdown-value","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/11\/5c\/115c8477d6438b3d6d8b19871535008b.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Revenue Log.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":3516,"type":"discussion","name":"update requests - how can find a summary of all pending update request from multiple sheets","excerpt":"is there any way to get a summary of pending update requesets from each user","categoryID":317,"dateInserted":"2015-11-10T10:28:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-02T13:20:39+00:00","insertUserID":4244,"insertUser":{"userID":4244,"name":"madhu krishnan","url":"https:\/\/community.smartsheet.com\/profile\/madhu%20krishnan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-11-10T10:25:09+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":13526,"lastUser":{"userID":13526,"name":"Marc Shecter","url":"https:\/\/community.smartsheet.com\/profile\/Marc%20Shecter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/7MDG7HO742ML\/nHOVUT0FAH0M1.jpg","dateLastActive":"2022-07-07T17:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":234,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/3516\/update-requests-how-can-find-a-summary-of-all-pending-update-request-from-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3516\/update-requests-how-can-find-a-summary-of-all-pending-update-request-from-multiple-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":237,"type":"discussion","name":"What is the easiest way to view all of the outstanding update requests, across all sheets, that I ha","excerpt":"I am using Smartsheet for a lot of different applications within our organization. I have a number of outstanding update requests - across a dozen sheets - but have no easy way of seeing the status of them all at once. Is there an easy way to do this?","categoryID":317,"dateInserted":"2015-05-03T16:04:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-02T12:48:12+00:00","insertUserID":838,"insertUser":{"userID":838,"name":"Tim Williamson","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Williamson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-05-12T13:37:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":13526,"lastUser":{"userID":13526,"name":"Marc Shecter","url":"https:\/\/community.smartsheet.com\/profile\/Marc%20Shecter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/7MDG7HO742ML\/nHOVUT0FAH0M1.jpg","dateLastActive":"2022-07-07T17:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":13,"countViews":316,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/237\/what-is-the-easiest-way-to-view-all-of-the-outstanding-update-requests-across-all-sheets-that-i-ha","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/237\/what-is-the-easiest-way-to-view-all-of-the-outstanding-update-requests-across-all-sheets-that-i-ha","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":267,"urlcode":"Energy & Utilities","name":"Energy & Utilities"}],"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":3783,"type":"discussion","name":"Is it possible to select more than one thing from a drop-down column?","excerpt":"We are struggling with the drop-down option as it seems like you can only select one option from the list. Is there a way of allowing users to select multiple options? Thanks! ","categoryID":317,"dateInserted":"2015-12-17T05:30:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-01T13:04:26+00:00","insertUserID":4491,"insertUser":{"userID":4491,"name":"Natalie Gangeswaran","url":"https:\/\/community.smartsheet.com\/profile\/Natalie%20Gangeswaran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-06-27T10:12:06+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":54,"countViews":1952,"score":null,"hot":54,"url":"https:\/\/community.smartsheet.com\/discussion\/3783\/is-it-possible-to-select-more-than-one-thing-from-a-drop-down-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3783\/is-it-possible-to-select-more-than-one-thing-from-a-drop-down-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":600,"type":"discussion","name":"Multiple choice option?","excerpt":"Good afternoon, A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic. Blessings, Loann","categoryID":317,"dateInserted":"2015-06-24T17:41:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-01T13:02:27+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2022-07-07T21:14:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":1295,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/600\/multiple-choice-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/600\/multiple-choice-option","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"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":282,"type":"discussion","name":"Calendar View | Start Day","excerpt":"I want to be able to display the calendar view with Monday as the fits day of the week (Mon- Sun) insetad of Sunday (Sun- Sat). Is this possible? ","categoryID":317,"dateInserted":"2015-05-09T18:48:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-01T02:40:23+00:00","insertUserID":1777,"insertUser":{"userID":1777,"name":"Dave Whitehead","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20Whitehead","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-05-09T18:40:57+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-04T23:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":20,"countViews":357,"score":null,"hot":20,"url":"https:\/\/community.smartsheet.com\/discussion\/282\/calendar-view-start-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/282\/calendar-view-start-day","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
类别
受欢迎的标签
You will need to substitute each space with %20 so when you are adding the Primary Column value use,<\/p>
=SUBSTITUTE([Primary Column]@row, \" \", \"%20\")\n<\/pre>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-03 11:16:07","updateUser":{"userID":152031,"name":"austinov","url":"https:\/\/community.smartsheet.com\/profile\/austinov","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T11:16:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":95022,"type":"question","name":"Determine if form submissions are missing","excerpt":"Hi there. We have 16 geographically dispersed service locations who perform time of service collections and bank deposits. Our finance team needs to capture and reconcile these collections & deposits on a daily basis. I have created a form to collect time of service collection information from each location, and I'm trying…","categoryID":322,"dateInserted":"2022-09-02T17:59:05+00:00","dateUpdated":null,"dateLastComment":"2022-09-02T20:41:55+00:00","insertUserID":99446,"insertUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":99446,"lastUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3324293460,"url":"https:\/\/community.smartsheet.com\/discussion\/95022\/determine-if-form-submissions-are-missing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95022\/determine-if-form-submissions-are-missing","format":"Rich","lastPost":{"discussionID":95022,"commentID":342319,"name":"Re: Determine if form submissions are missing","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342319#Comment_342319","dateInserted":"2022-09-02T20:41:55+00:00","insertUserID":99446,"insertUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-02T20:46:38+00:00","dateAnswered":"2022-09-02T20:41:55+00:00","acceptedAnswers":[{"commentID":342319,"body":"Hi again. I figured out the core formula I needed, so I thought I'd update my post in case others have similar questions in the future.<\/p>
Form for submission is part of \"Daily Collections\" sheet, and SITE NAME is the site submitting the form. I created an Audit sheet with a list of SITE NAME's, and look to the Daily Collections sheet to determine if at least one submission matches with SITE NAME, resulting in \"Y\" or \"N\".<\/p>
=IF(COUNTIF({Daily Collections SITE NAME}, =SITE NAME@row) > 0, \"Y\", \"N\")<\/p>
Thanks! 😁<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-02 20:46:38","updateUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":95016,"type":"question","name":"Countifs with multiple sheet references and CONTAINS","excerpt":"Hi! I am struggling with how to build the correct formula to provide the result of the following scenario: I am using the Smartsheet \"Fruit Sheet\" to create a formula in the Smartsheet \"Orchard\" Search \"Fruit Sheet\" for any \"Apples\" that may be \"Red\" in the \"Summer\" The sheet has several fruits and several apples. The…","categoryID":322,"dateInserted":"2022-09-02T14:58:09+00:00","dateUpdated":"2022-09-02T15:08:46+00:00","dateLastComment":"2022-09-02T15:55:50+00:00","insertUserID":152024,"insertUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":152024,"lastUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3324266039,"url":"https:\/\/community.smartsheet.com\/discussion\/95016\/countifs-with-multiple-sheet-references-and-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95016\/countifs-with-multiple-sheet-references-and-contains","format":"Rich","lastPost":{"discussionID":95016,"commentID":342299,"name":"Re: Countifs with multiple sheet references and CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342299#Comment_342299","dateInserted":"2022-09-02T15:55:50+00:00","insertUserID":152024,"insertUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-02T15:55:57+00:00","dateAnswered":"2022-09-02T15:46:55+00:00","acceptedAnswers":[{"commentID":342297,"body":"
