探索。问。回答

[Start Date]@row, \"Red\",…","categoryID":322,"dateInserted":"2023-04-23T07:04:53+00:00","dateUpdated":null,"dateLastComment":"2023-04-23T14:56:57+00:00","insertUserID":160775,"insertUser":{"userID":160775,"name":"Alex Szalkowski","title":"Alex Szalkowski","url":"https:\/\/community.smartsheet.com\/profile\/Alex%20Szalkowski","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-25T16:41:28+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-05-09T06:29:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3364497110,"url":"https:\/\/community.smartsheet.com\/discussion\/104357\/incorrect-argument-set-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104357\/incorrect-argument-set-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-23T08:23:21+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":[],"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":104359,"type":"question","name":"Dynamic View Logic - Field Not Required","excerpt":"Hi, I'm setting up a Dynamic View and trying to use logic in the Details Panel. I want several fields to be shown when the answer to a certain question is Yes. However one of the fields that I want to be shown will record a date when an event has finished and therefore wont be populated for some time. When I set up the…","categoryID":321,"dateInserted":"2023-04-23T12:08:40+00:00","dateUpdated":null,"dateLastComment":"2023-04-23T14:55:11+00:00","insertUserID":158920,"insertUser":{"userID":158920,"name":"TomW","title":"","url":"https:\/\/community.smartsheet.com\/profile\/TomW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-28T16:10:20+00:00","banned":0,"punished":0,"private":true,"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-05-09T06:29:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3364514031,"url":"https:\/\/community.smartsheet.com\/discussion\/104359\/dynamic-view-logic-field-not-required","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104359\/dynamic-view-logic-field-not-required","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-23T14:55:11+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":443,"urlcode":"dynamic-view","name":"Dynamic 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":102093,"type":"question","name":"Get Summary Sheet Via API in to Power BI","excerpt":"I know the Power BI connector cant get data from a summary sheet report but can the API get this data? If yes does anyone have an example I can use? Many thanks Martin","categoryID":320,"dateInserted":"2023-03-03T16:55:33+00:00","dateUpdated":null,"dateLastComment":"2023-04-23T13:59:43+00:00","insertUserID":120078,"insertUser":{"userID":120078,"name":"Martin Perry","url":"https:\/\/community.smartsheet.com\/profile\/Martin%20Perry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9XQRAC1QG71X\/n98KI4IVDXNZ1.jpg","dateLastActive":"2023-04-26T19:01:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":120078,"lastUser":{"userID":120078,"name":"Martin Perry","url":"https:\/\/community.smartsheet.com\/profile\/Martin%20Perry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9XQRAC1QG71X\/n98KI4IVDXNZ1.jpg","dateLastActive":"2023-04-26T19:01:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":93,"score":null,"hot":3360122716,"url":"https:\/\/community.smartsheet.com\/discussion\/102093\/get-summary-sheet-via-api-in-to-power-bi","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102093\/get-summary-sheet-via-api-in-to-power-bi","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-04T07:13:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":104358,"type":"idea","name":"Automatically Delete Rows","excerpt":"We need this feature please","categoryID":349,"dateInserted":"2023-04-23T08:53:43+00:00","dateUpdated":null,"dateLastComment":"2023-04-23T08:53:43+00:00","insertUserID":158918,"insertUser":{"userID":158918,"name":"Jen K.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20K.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!gofq5-ubOzM!A5dpn8Pyg7M!Z2KPLGGuGMZ","dateLastActive":"2023-05-03T06:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158918,"lastUser":{"userID":158918,"name":"Jen K.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20K.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!gofq5-ubOzM!A5dpn8Pyg7M!Z2KPLGGuGMZ","dateLastActive":"2023-05-03T06:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":22,"score":2,"hot":1682240623,"url":"https:\/\/community.smartsheet.com\/discussion\/104358\/automatically-delete-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104358\/automatically-delete-rows","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":104073,"type":"question","name":"How to calculate positive & negative time","excerpt":"Good day everyone, I've designed a smartsheet for an airline operation and dealing with standard departure \/ arrival times versus estimated departure \/ arrival times. I have this formula that works great: =IF([ETA\/ATA (LT)]@row <> \"\", ((VALUE(LEFT([ETA\/ATA (LT)]@row, 2)) + IF([ETA\/ATA (LT)]@row < [STA (LT)]@row, 24)) +…","categoryID":322,"dateInserted":"2023-04-16T19:53:34+00:00","dateUpdated":"2023-04-16T23:27:57+00:00","dateLastComment":"2023-04-22T19:59:30+00:00","insertUserID":160532,"insertUser":{"userID":160532,"name":"Carmen Mansfield","url":"https:\/\/community.smartsheet.com\/profile\/Carmen%20Mansfield","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jKkr4yu8z7o!CRjqAv-S8bo!ZT_DT8-nHYX","dateLastActive":"2023-04-22T19:57:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":160532,"lastUserID":160532,"lastUser":{"userID":160532,"name":"Carmen Mansfield","url":"https:\/\/community.smartsheet.com\/profile\/Carmen%20Mansfield","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jKkr4yu8z7o!CRjqAv-S8bo!ZT_DT8-nHYX","dateLastActive":"2023-04-22T19:57:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":84,"score":null,"hot":3363873184,"url":"https:\/\/community.smartsheet.com\/discussion\/104073\/how-to-calculate-positive-negative-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104073\/how-to-calculate-positive-negative-time","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-17T14:06:38+00:00","dateAnswered":"2023-04-17T00:04:18+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":[],"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":104354,"type":"idea","name":"collaborates list for user to edit the additional character on different sheets","excerpt":"I can edit my Smartsheet contact list as 06160056: Add marks or additional information on Shared user's name by Gerson. However, all users may play different roles on different sheets as I used it for all partners. Such as one company could be my customer \/ supplier \/ co-worker for different projects. But they are same…","categoryID":349,"dateInserted":"2023-04-22T17:03:44+00:00","dateUpdated":null,"dateLastComment":"2023-04-22T17:03:44+00:00","insertUserID":160774,"insertUser":{"userID":160774,"name":"Daniel Li","title":"Customer Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Li","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-22T17:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":160774,"lastUser":{"userID":160774,"name":"Daniel Li","title":"Customer Support Manager","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Li","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-22T17:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":23,"score":1,"hot":1682183324,"url":"https:\/\/community.smartsheet.com\/discussion\/104354\/collaborates-list-for-user-to-edit-the-additional-character-on-different-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104354\/collaborates-list-for-user-to-edit-the-additional-character-on-different-sheets","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92401,"type":"idea","name":"Shortcut to Dashboard Header \/ Bookmarks","excerpt":"I have a pretty big dashboard of resources that are grouped under 9 headers. The top of my dashboard has a table of contents. Is there anyway to link a jump to those headers within the same dashboard? A link to a bookmark within the dashboard (not to another sheet)?","categoryID":349,"dateInserted":"2022-06-20T22:04:20+00:00","dateUpdated":"2023-04-17T13:40:16+00:00","dateLastComment":"2023-04-22T07:28:39+00:00","insertUserID":135919,"insertUser":{"userID":135919,"name":"Drea Mora","url":"https:\/\/community.smartsheet.com\/profile\/Drea%20Mora","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ut1Dp0UyliQ!5NDCOclHZ5Y!r2ab8mv_6rL","dateLastActive":"2023-03-30T20:32:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":137089,"lastUser":{"userID":137089,"name":"Adrian @ Chess","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-04-22T07:34:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":228,"score":21,"hot":3337921679,"url":"https:\/\/community.smartsheet.com\/discussion\/92401\/shortcut-to-dashboard-header-bookmarks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92401\/shortcut-to-dashboard-header-bookmarks","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":100371,"type":"idea","name":"Organizing Attachments by Folders","excerpt":"I am trying to use Smartsheet to manage several grant programs, from the application process to post-award reporting. The platform lends itself to do this easily, but one nuisance is having to deal with a lot of attachments without any way to organize them. It would be so much easier if we were able to organize attachments…","categoryID":349,"dateInserted":"2023-01-30T16:56:50+00:00","dateUpdated":null,"dateLastComment":"2023-04-22T07:01:52+00:00","insertUserID":153881,"insertUser":{"userID":153881,"name":"tthacker","url":"https:\/\/community.smartsheet.com\/profile\/tthacker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BIktgaICKzo!g8lvp2Y_BQI!livQATYCeOg","dateLastActive":"2023-01-30T16:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137089,"lastUser":{"userID":137089,"name":"Adrian @ Chess","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-04-22T07:34:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"score":4,"hot":3357247122,"url":"https:\/\/community.smartsheet.com\/discussion\/100371\/organizing-attachments-by-folders","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100371\/organizing-attachments-by-folders","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">