欢迎来到Smartsheet论坛档案


本论坛中的帖子不再被监控准确性,其内容可能不再是最新的。如果这里有您感兴趣的讨论,并且您想找到(或创建)一个更最新的版本,请访问当前论坛。

创建Smartsheet API报表

你好,

我们有很多报告,它们只有很小的差异。

通常它只是一个过滤器,例如“assigned to”的名称。

如果我们必须稍微更改这些报告,我们就必须手动更改所有报告。

是否可以用API创建/更改报告?

我试图这样做,但我没有在API (Smartsheet Java SDK)中找到它。

要创建文件夹,可以这样做:

文件夹Folder = new Folder. createfolderbuilder()。setName(“新文件夹”).build ();

文件夹= smartsheet.homeReso欧宝体育app官方888urces().folderResources().createFolder(文件夹);

但是报表资源没有创建方法

report = smartsheet.report欧宝体育app官方888Resources().createReport(报告)

如果这个特性不存在,这是我的特性请求:-)

非常感谢。

评论

这次讨论已经结束。
Hello everyone, <\/p>

We thank you for your patience while we iron out some of the kinks with the new Search UI. We've released two updates today that resolve some of the concerns raised here.<\/p>

  1. If you are searching for a numeric or alphanumeric term, you will get an exact match of the search term you entered, thereby resolving some of the previous search relevance concerns.<\/li>
  2. When clicking on a search result, you will go directly to that result instead of the top of the sheet containing that result. However, if you only want to go to the sheet containing the search result, click the icon to the right of the sheet name. <\/li><\/ol>

    We'll keep you updated with any new improvements to the Search experience.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 12:13:12","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-16T09:10:31+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":3}],"tags":[]},{"discussionID":98881,"type":"question","name":"Add image to the Smartsheet Form (Questionnaire)","excerpt":"Hi Smartsheet Form Expert, I have created a Form (Questionnaire). One of the questions in the Questionnaire is as follows: \"Is there any other information you would like to share regarding your suggestion?\" In Smartssheet Form, would it be possible for the respondents to insert\/attach an image to support their response?…","categoryID":321,"dateInserted":"2022-12-16T22:32:35+00:00","dateUpdated":null,"dateLastComment":"2022-12-16T23:08:07+00:00","insertUserID":129126,"insertUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":129126,"lastUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3342463242,"url":"https:\/\/community.smartsheet.com\/discussion\/98881\/add-image-to-the-smartsheet-form-questionnaire","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98881\/add-image-to-the-smartsheet-form-questionnaire","format":"Rich","lastPost":{"discussionID":98881,"commentID":354747,"name":"Re: Add image to the Smartsheet Form (Questionnaire)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354747#Comment_354747","dateInserted":"2022-12-16T23:08:07+00:00","insertUserID":129126,"insertUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O7QLMINQ41YZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-16T23:06:45+00:00","dateAnswered":"2022-12-16T22:45:02+00:00","acceptedAnswers":[{"commentID":354741,"body":"

    @Marie_T<\/a> <\/p>

    \n
    \n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

    After putting this box into your form, you can enter \"Help Text\" to give the area of the form context.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-16 23:06:45","updateUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":98874,"type":"question","name":"Child-parent hierarchy does not calculate total duration","excerpt":"I have a child-parent hierarchy setup for multiple categories, it all rolls up correctly but only one frame calculates the total duration. What am I doing wrong?","categoryID":321,"dateInserted":"2022-12-16T19:30:27+00:00","dateUpdated":null,"dateLastComment":"2022-12-17T01:58:42+00:00","insertUserID":156089,"insertUser":{"userID":156089,"name":"kathleens2020","url":"https:\/\/community.smartsheet.com\/profile\/kathleens2020","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-17T01:59:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156089,"lastUser":{"userID":156089,"name":"kathleens2020","url":"https:\/\/community.smartsheet.com\/profile\/kathleens2020","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-17T01:59:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3342463149,"url":"https:\/\/community.smartsheet.com\/discussion\/98874\/child-parent-hierarchy-does-not-calculate-total-duration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98874\/child-parent-hierarchy-does-not-calculate-total-duration","format":"Rich","lastPost":{"discussionID":98874,"commentID":354751,"name":"Re: Child-parent hierarchy does not calculate total duration","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354751#Comment_354751","dateInserted":"2022-12-17T01:58:42+00:00","insertUserID":156089,"insertUser":{"userID":156089,"name":"kathleens2020","url":"https:\/\/community.smartsheet.com\/profile\/kathleens2020","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-17T01:59:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-17T01:56:17+00:00","dateAnswered":"2022-12-16T23:03:32+00:00","acceptedAnswers":[{"commentID":354745,"body":"

    @kathleens2020<\/a> <\/p>

    After reading up more on it, I think the answer is that the parent row Duration is calculated from the Start Date of the first Child Row to the End Date of the last Child Row. So since you don't have start and end dates on all of those child rows you're not being given a sum.<\/p>

    Try filling in those dates temporarily and I bet it'll add that then.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-17 01:56:17","updateUser":{"userID":156089,"name":"kathleens2020","url":"https:\/\/community.smartsheet.com\/profile\/kathleens2020","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-17T01:59:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":98871,"type":"question","name":"Why am I get an error when I added IFERROR to formula:","excerpt":"=IFERROR(YEAR([Current Charleys GO]@row) - YEAR([Walmart Revised GO date from 7\/8]@row)) * 12 + IFERROR(MONTH([Current Charleys GO]@row) - MONTH([Walmart Revised GO date from 7\/8]@row)), \"//www.santa-greenland.com/community/discussion/6872/\")","categoryID":322,"dateInserted":"2022-12-16T18:36:06+00:00","dateUpdated":"2022-12-16T18:36:42+00:00","dateLastComment":"2022-12-16T21:09:52+00:00","insertUserID":141275,"insertUser":{"userID":141275,"name":"Meagan80","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Meagan80","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LVM2A6KZT546\/n6XX2KVCBG8W2.jpg","dateLastActive":"2022-12-16T21:08:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":141275,"lastUserID":141275,"lastUser":{"userID":141275,"name":"Meagan80","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Meagan80","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LVM2A6KZT546\/n6XX2KVCBG8W2.jpg","dateLastActive":"2022-12-16T21:08:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3342441958,"url":"https:\/\/community.smartsheet.com\/discussion\/98871\/why-am-i-get-an-error-when-i-added-iferror-to-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98871\/why-am-i-get-an-error-when-i-added-iferror-to-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98871,"commentID":354735,"name":"Re: Why am I get an error when I added IFERROR to formula:","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354735#Comment_354735","dateInserted":"2022-12-16T21:09:52+00:00","insertUserID":141275,"insertUser":{"userID":141275,"name":"Meagan80","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Meagan80","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LVM2A6KZT546\/n6XX2KVCBG8W2.jpg","dateLastActive":"2022-12-16T21:08:51+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-12-16T21:09:23+00:00","dateAnswered":"2022-12-16T20:10:44+00:00","acceptedAnswers":[{"commentID":354731,"body":"

    Let the IFERROR surround your whole formula. Try <\/p>

    =IFERROR(YEAR([Current Charleys GO]@row) - YEAR([Walmart Revised GO date from 7\/8]@row) * 12 + MONTH([Current Charleys GO]@row) - MONTH([Walmart Revised GO date from 7\/8]@row), \"//www.santa-greenland.com/community/discussion/6872/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-16 21:09:23","updateUser":{"userID":141275,"name":"Meagan80","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Meagan80","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LVM2A6KZT546\/n6XX2KVCBG8W2.jpg","dateLastActive":"2022-12-16T21:08:51+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">