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.

OneDrive - Central Account

David Sornig
edited 12/09/19 inArchived 2016 Posts

I know you can upload from OneDrive to Smartsheet and the document actually be stored on OneDrive. The problem is I don;t want documents stored in each individual person OneDrive. I want any document uploaded to go to a common OneDrive account. Basically if I share a sheet with an external user and request files from them I want it to go to my OneDrive account and not his.

Is this possible?

Thanks,

David

Tags:

Comments

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭
    edited 09/29/16

    David what you say makes perfect sense and in Dropbox you just need to make sure the document being shared resides in a Folder shared to those that need to access it.

    One Drive should be the same surely?

    Then you have just one LIVE copy of the document for all to view or edit.

    Regards

    RichardR

  • David Sornig
    edited 09/30/16

    Richard,

    Thanks for the reply. I sent uploaded a document from our corp. OneDrive account. Everyone can see the document and has access to it. I then requested an external cleint to upload a file using Smartsheet. The external user does not have a OneDrive account. When he uploads the file it just goes to SmartSheet. This is HIPPA data and SmartSheet is not HIPPA compliant. I would like when the external user clicks on attachment in SmartSheet that it uploads to our OneDrive account even if the user does or does not have a OneDrive account.

    Thanks,

    David

This discussion has been closed.
\n \n https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula\n <\/a>\n<\/div>\n

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/6195/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/6195/\", 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/6195/\", 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":[]}">

Trending Posts