Data Shuttle connection to Sharepoint disconnects randomally

SmartSheetUser201
SmartSheetUser201 ✭
inAdd Ons and Integrations

I have a recurring Data Shuttle process and randomly it'll stop running. Upon inspection, I'll see the connection between Sharepoint and Data Shuttle has been disconnected and I'm forced to authenticate again.

Has anyone experienced this or know if there's any documentation about this?

Tags:
· Share on Facebook Share on Twitter

Best Answer

  • Hamza1
    Hamza1 Moderator
    edited 06/21/23 Answer ✓

    @SmartSheetUser201

    If the behaviour occurs randomly or its intermittent, please submit a ticket to the Support team through thecustomer support portalproviding the following information:

    • Screen recording / screen captures of your workflow set-up
    • Sheet URL that's being connected
    • Date/Time that you last created/connected the workflow
    • Date/Time that you last noticed it was disconnected

    You may also want to run through the initial troubleshooting stepsin this articleto see if it helps.


    Thanks,

    Hamza

    · Share on Facebook Share on Twitter

Answers

  • Hamza1
    Hamza1 Moderator
    edited 06/21/23 Answer ✓

    @SmartSheetUser201

    If the behaviour occurs randomly or its intermittent, please submit a ticket to the Support team through thecustomer support portalproviding the following information:

    • Screen recording / screen captures of your workflow set-up
    • Sheet URL that's being connected
    • Date/Time that you last created/connected the workflow
    • Date/Time that you last noticed it was disconnected

    You may also want to run through the initial troubleshooting stepsin this articleto see if it helps.


    Thanks,

    Hamza

    · Share on Facebook Share on Twitter

Categories

Hi @Sachiko Kagami<\/a>,<\/p>

The WORKDAY function is what you're after here.<\/p>

\n \n https:\/\/help.smartsheet.com\/function\/workday\n <\/a>\n<\/div>

In your case, I think the following should work:<\/p>

=COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, \"Close Gap\", {Customer Escalation Request Date}, WORKDAY(TODAY(),-1)<\/p>

This will do the check for yesterday, skipping weekends. Public holidays aren't automatically in there, but you can add these as per the link.<\/p>

Hope this helps - if there are any issues then just post! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106910,"type":"question","name":"Paid for ProSupport but can't access it","excerpt":"I upgraded my business plan to include pro support. However, there are no phone numbers listed under the Contact Us section. My only option is to file a support ticket. On 6\/5, I emailed Daniel Tiner, the sales rep who completed the purchase for me. I have not received a response. This is very frustrating as I paid for the…","categoryID":321,"dateInserted":"2023-06-26T17:57:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T20:54:56+00:00","insertUserID":160597,"insertUser":{"userID":160597,"name":"Melydia Clewell","title":"System Admin","url":"https:\/\/community.smartsheet.com\/profile\/Melydia%20Clewell","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiEHafKTTFY_CU4Fe2nykN67iSnlxIdPBnF0DMvfS4=s96-c","dateLastActive":"2023-06-26T20:53:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160597,"lastUser":{"userID":160597,"name":"Melydia Clewell","title":"System Admin","url":"https:\/\/community.smartsheet.com\/profile\/Melydia%20Clewell","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiEHafKTTFY_CU4Fe2nykN67iSnlxIdPBnF0DMvfS4=s96-c","dateLastActive":"2023-06-26T20:53:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":null,"hot":3375617561,"url":"https:\/\/community.smartsheet.com\/discussion\/106910\/paid-for-prosupport-but-cant-access-it","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106910\/paid-for-prosupport-but-cant-access-it","format":"Rich","tagIDs":[207,281,446],"lastPost":{"discussionID":106910,"commentID":382447,"name":"Re: Paid for ProSupport but can't access it","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382447#Comment_382447","dateInserted":"2023-06-26T20:54:56+00:00","insertUserID":160597,"insertUser":{"userID":160597,"name":"Melydia Clewell","title":"System Admin","url":"https:\/\/community.smartsheet.com\/profile\/Melydia%20Clewell","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiEHafKTTFY_CU4Fe2nykN67iSnlxIdPBnF0DMvfS4=s96-c","dateLastActive":"2023-06-26T20:53:23+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":"2023-06-26T20:55:04+00:00","dateAnswered":"2023-06-26T20:54:56+00:00","acceptedAnswers":[{"commentID":382447,"body":"

@Steve_Mitchell<\/a>, thank you! I just filed a ticket. i appreciate your help.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":106894,"type":"question","name":"How to Count a value in a drop down \/ multi-selection list?","excerpt":"Hi, I'm wanting to count the total amount time this value \"VAVE\" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…","categoryID":321,"dateInserted":"2023-06-26T15:09:07+00:00","dateUpdated":"2023-06-26T15:09:27+00:00","dateLastComment":"2023-06-26T20:54:24+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-27T13:13:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162246,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T17:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":62,"score":null,"hot":3375609211,"url":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106894,"commentID":382446,"name":"Re: How to Count a value in a drop down \/ multi-selection list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382446#Comment_382446","dateInserted":"2023-06-26T20:54:24+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T17:55:47+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\/LKT88AUTSMAT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-26T16:54:33+00:00","dateAnswered":"2023-06-26T16:44:18+00:00","acceptedAnswers":[{"commentID":382355,"body":"

@Shawn_K2<\/a> UGH I make a mistake. I copied your formula without looking at it close enough 😜<\/span><\/p>


<\/p>

try =COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"))<\/p>"},{"commentID":382446,"body":"

@Shawn_K2<\/a> <\/p>

=COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"), {CPR Brand}, HAS(@cell, \"ING\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5413,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet

  • 如何show data of previous working day?

    For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, "Close Gap", {Customer Escalation Request Date}, TODAY(-1)) I'm…

  • Paid for ProSupport but can't access it

    I upgraded my business plan to include pro support. However, there are no phone numbers listed under the Contact Us section. My only option is to file a support ticket. On 6/5, I emailed Daniel Tiner, the sales rep who completed the purchase for me. I have not received a response. This is very frustrating as I paid for the…

  • 如何Count a value in a drop down / multi-selection list?

    Hi, I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…