Smartsheet Form & File Attachment

Syd
Syd ✭
inSmartsheet Basics

Hello, is it possible to have the file uploaded on a smartsheet form to be attached to the email notification?

· Share on Facebook Share on Twitter

Best Answer

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭
    Answer ✓

    @Syd- okay, I attached a word doc to this comment that explains it step by step. Basically, I have my Google Chrome browser laid out to ask me anytime I download a file, where I want the file saved. Some automatically default it to a certain folder, and sometimes it just is defaulted automatically to a downloads folder... I'd check that as well, or even check the downloads folder to verify. Sometimes, it may download and send it to a folder that you may not know its sending to.


    Let me know if this helps at all!


    Attachments in Smartsheet 6.15.23.docx


    · Share on Facebook Share on Twitter

Answers

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭

    Hi@Syd-


    From my experience, the only way to push the attachment through is by using the generate document/docusign feature. We currently use adobe sign, and have a specific method that allows a process we have to get the document and sign the document via adobe sign... but it is more manually intensive than the docusign method. From there, docusign would be the deliverer of the document when the document is signed, etc, as normal.


    You could send the file directly from the attachments tab, by clicking the file and sending it to the individuals you'd like to -- but I don't believe it can be triggered yet by an automated notification.


    Would love others' thoughts on this though -- there are workarounds to this if you are skilled with scripting but it requires pulling the file using power automate into a folder stored on your server and then compiling the notification from your own system.

    · Share on Facebook Share on Twitter
  • Syd
    Syd ✭

    Thanks@StevenBlackburnMBA, just to confirm. The email notification currently shows a file was uploaded to the form, but there isn't a way for it to actually attach the uploaded file?

    Smartsheet Email.JPG

    @StevenBlackburnMBA

    · Share on Facebook Share on Twitter
  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭

    @Syd- my apologies, I misunderstood the question. You can attach the files and review them that way... are you having trouble opening?


    They should be accessible by clicking and downloading the file... but I don't believe you have access to separate who sees what... if its submitted, whoever is on the notification should have access to any of the attached files.

    · Share on Facebook Share on Twitter
  • Syd
    Syd ✭

    @StevenBlackburnMBAcorrect, I am unable to download the file by clicking on it in the email.

    Thanks for your help btw!

    · Share on Facebook Share on Twitter
  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭

    No problem at all... let me see if I can send some screenshots to show from my perspective. Hopefully it helps!!

    · Share on Facebook Share on Twitter
  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭
    Answer ✓

    @Syd- okay, I attached a word doc to this comment that explains it step by step. Basically, I have my Google Chrome browser laid out to ask me anytime I download a file, where I want the file saved. Some automatically default it to a certain folder, and sometimes it just is defaulted automatically to a downloads folder... I'd check that as well, or even check the downloads folder to verify. Sometimes, it may download and send it to a folder that you may not know its sending to.


    Let me know if this helps at all!


    Attachments in Smartsheet 6.15.23.docx


    · Share on Facebook Share on Twitter
  • Syd
    Syd ✭

    @StevenBlackburnMBAyou are the best! I was able to create the automation workflow and the testing worked! Fingers crossed our client finds it feasible.

    You're awesome!

    · Share on Facebook Share on Twitter
  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭

    No problem, I’m glad you got it working!!

    · 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-27T15:54:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":61,"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-27T15:54:57+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

  • How to 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…

  • How to 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…