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.
附件工作流援助
Hi everyone,
I am trying to create a workflow that is triggered by attaching a file to a row on a particular sheet. What I would like to do is once the attachment is added to the sheet, the file is also copied to a repository on Box. I looked at using Zapier to automate the process, but it the Zapier flow requires a file object or a URL to the file to execute the save to Box. I am not sure how to get the url for the attachment in an automated way. I would normally have the user just save the attachment to Box, but want to ensure that the file goes to the correct location each time vs. someone putting it in the wrong folder. I am also not sure about the users credentials when saving to Box. I assume every user who adds an attachment must have a Box account? Thoughts on options would be greatly appreciated.
Thanks!!
Comments
-
Kennedy Stomps EmployeeHi Bob-- This is a good question. I don't know much about our integration with Box, so I've reached out to a colleague to see if we might have a solution for this that I'm just not aware of. I'll update you when I have more information!
-
Bob Emerick ✭✭
Thanks for taking a look Kennedy!
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/5676/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/5676/\", 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/5676/\", 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":[]}">
