欢迎来到Smartsheet论坛档案


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

2017年帖子

讨论表

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/categories/c2017/\")","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/categories/c2017/\")<\/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":[]}">