Importing and Exporting

Discussion List

  • Data Uploader Filtering
    In Apps, Integrations, and Add Ons
    Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formul…
    435 6
    435 views 6 comments Most recent by Genevieve P. Apps, Integrations, and Add Ons
  • Converting 2020-05-20T12:38:08.063 to a date format
    In Formulas and Functions
    Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no optio…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • last, first to [email protected]
    In Formulas and Functions
    Is there a way to take a column: Last, First and build [email protected] Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
    Answered - Pending Review
    114 1
    Answered - Pending Review 114 views 1 comment Most recent by Jason Tarpinian Formulas and Functions
  • Form Dropdown Help
    In Using Smartsheet
    I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on ea…
    Answered - Pending Review
    31 1
    Answered - Pending Review 31 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Value in one sheet create a "populate" trigger in another sheet
    In Using Smartsheet
    Good afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/esti…
    660 4
    660 views 4 comments Most recent by Pam Grant Using Smartsheet
  • Merge all attachments of a sheet into one PDF?
    In Apps, Integrations, and Add Ons
    Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be abl…
    Answered - Pending Review
    86 3
    Answered - Pending Review 86 views 3 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Formatting when exporting to pdf
    In Using Smartsheet
    Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. Lauren
    272 7
    272 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Smartsheet to Word Document
    In Using Smartsheet
    One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transfo…
    1747 5
    1.7K views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Copy and keep cell value based on day of the week.
    In Formulas and Functions
    Hello All, Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed? Backstory: I currently have a dashboar…
    Answered - Pending Review
    494 5
    Answered - Pending Review 494 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Importing Excel Spreadsheets into Smartsheet
    In Using Smartsheet
    I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I i…
    Accepted
    248 7
    Accepted Answer 248 views 7 comments Most recent by Andrée Starå Using Smartsheet