Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Show Attachments of Folders
We like to see the attachments of a folder directly beside the sheets of the folder. I marked this in red in the screenshot. We think this would make it easier to find the attachments. Possible?
Comments
-
Shaine Greenwood Employee
Hello Volker—there isn't a way to store attachments in a folder on the Home tab, they can only be stored on the workspace, sheet, or row level via the attachments (paperclip) icon.
I'll get your vote down on our enhancement request list for a way to store them in a folder.
Categories
Hi, <\/p>
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=IF([Date Reported]@row <> \"//www.santa-greenland.com/community/discussion/6292/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/6292/\", NETDAYS([Date Reported]@row, TODAY()), NETDAYS([Date Reported]@row, [Resolution Date]@row)))<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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"}]},{"discussionID":109470,"type":"question","name":"Trying to get OR to work with Countifs","excerpt":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks! =COUNTIFS({CNC, CMM, and BL Request Sheet Need by date},…","snippet":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is…","categoryID":322,"dateInserted":"2023-08-25T15:27:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T17:16:16+00:00","insertUserID":165685,"insertUser":{"userID":165685,"name":"Wade Herrin","title":"Cell Leader","url":"https:\/\/community.smartsheet.com\/profile\/Wade%20Herrin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Ztvd2bxcfH4!c6jdhwhyx7Q!hsgJTX6RzVB","dateLastActive":"2023-08-25T18:16:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3385962845,"url":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","format":"Rich","lastPost":{"discussionID":109470,"commentID":392637,"name":"Re: Trying to get OR to work with Countifs","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392637#Comment_392637","dateInserted":"2023-08-25T17:16:16+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T17:07:38+00:00","dateAnswered":"2023-08-25T17:07:32+00:00","acceptedAnswers":[{"commentID":392632,"body":" Nailed it, thank you!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":109468,"type":"question","name":"Compare duplicate rows, identify most recently added","excerpt":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank…","snippet":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date…","categoryID":322,"dateInserted":"2023-08-25T15:12:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:33:42+00:00","insertUserID":138358,"insertUser":{"userID":138358,"name":"Stefanie S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefanie%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T15:56:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3385959358,"url":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","format":"Rich","lastPost":{"discussionID":109468,"commentID":392620,"name":"Re: Compare duplicate rows, identify most recently added","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392620#Comment_392620","dateInserted":"2023-08-25T16:33:42+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VIINAL1P3WNF\/screenshot-2023-08-25-at-11-08-09-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-08-25 at 11.08.09 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:58:16+00:00","dateAnswered":"2023-08-25T15:52:39+00:00","acceptedAnswers":[{"commentID":392600,"body":" This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.<\/p> =IF(AND([Created]@row <> \"//www.santa-greenland.com/community/discussion/6292/\", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">