SDK -每个文件设置一个工作日的开始/结束时间
你好,
用户可以设置每个文件的工作日长度。Smartsheet以某种方式使用此值来设置工作日的一些内部开始/结束时间。通过API提供这些值会很有用。或者至少分享公式来做计算。
谢谢
标签:
类别
2023-05-15T14:10:34.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106451,"type":"idea","name":"Add or Sync Billing Schedules into SmartSheets Resource Management","excerpt":"Currently there isn't a way to add or sync billing schedules into SmartSheets for revenue projections. The revenue is only projected by the system using hours and bill rates. For projects that are not time & materials, this is not useful.","categoryID":349,"dateInserted":"2023-06-14T18:45:14+00:00","dateUpdated":"2023-06-14T18:45:48+00:00","dateLastComment":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162377,"lastUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":1,"hot":3373536962,"url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","format":"Rich","tagIDs":[363,468],"lastPost":{"discussionID":106451,"name":"Add or Sync Billing Schedules into SmartSheets Resource Management","url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","dateInserted":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]},{"discussionID":106339,"type":"idea","name":"Single Row Timeline","excerpt":"Would love to see a single row timeline that provides a condensed view for senior leadership. This is one capability that is asked for a lot, but currently is not available.","categoryID":349,"dateInserted":"2023-06-12T20:56:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T13:00:21+00:00","insertUserID":107206,"insertUser":{"userID":107206,"name":"Pam Ferguson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pam%20Ferguson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!wc1AMAYHDEQ!woNBt-bwO3Q!6Y9I4ypKEQB","dateLastActive":"2023-06-13T19:25:39+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":162408,"lastUser":{"userID":162408,"name":"LLuckmann","url":"https:\/\/community.smartsheet.com\/profile\/LLuckmann","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfsdw9R-87c7VHfaw9L9oosQZ9zJR62UkaZN8E37w=s96-c","dateLastActive":"2023-06-15T13:08:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":38,"score":2,"hot":3373439201,"url":"https:\/\/community.smartsheet.com\/discussion\/106339\/single-row-timeline","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106339\/single-row-timeline","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106339,"commentID":380756,"name":"Re: Single Row Timeline","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380756#Comment_380756","dateInserted":"2023-06-15T13:00:21+00:00","insertUserID":162408,"insertUser":{"userID":162408,"name":"LLuckmann","url":"https:\/\/community.smartsheet.com\/profile\/LLuckmann","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfsdw9R-87c7VHfaw9L9oosQZ9zJR62UkaZN8E37w=s96-c","dateLastActive":"2023-06-15T13:08:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SUNNQ4CW55GQ\/timeline-visual-sample-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"timeline_visual_sample.PNG"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106271,"type":"idea","name":"Print Dynamic View","excerpt":"Print or export the Dynamic View in order to distribute it to students and faculty.","categoryID":349,"dateInserted":"2023-06-09T14:39:25+00:00","dateUpdated":"2023-06-14T12:54:55+00:00","dateLastComment":"2023-06-14T12:29:37+00:00","insertUserID":158793,"insertUser":{"userID":158793,"name":"megarceau","url":"https:\/\/community.smartsheet.com\/profile\/megarceau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:37:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":136233,"lastUser":{"userID":136233,"name":"Dawn McCallister","url":"https:\/\/community.smartsheet.com\/profile\/Dawn%20McCallister","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtccca_-90U_9MnORlEgzpUBEO8EeqyMzWNSMIPScQ=s96-c","dateLastActive":"2023-06-14T14:55:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":4,"hot":3373072460,"url":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","format":"Rich","tagIDs":[363,443,445],"lastPost":{"discussionID":106271,"commentID":380450,"name":"Re: Print Dynamic View","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380450#Comment_380450","dateInserted":"2023-06-14T12:29:37+00:00","insertUserID":136233,"insertUser":{"userID":136233,"name":"Dawn McCallister","url":"https:\/\/community.smartsheet.com\/profile\/Dawn%20McCallister","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtccca_-90U_9MnORlEgzpUBEO8EeqyMzWNSMIPScQ=s96-c","dateLastActive":"2023-06-14T14:55:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":4}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-15T14%3A10%3A34%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":165,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
