Importing and Exporting

Discussion List

  • How to Use VLOOKUP and SUMIFS
    In Formulas and Functions
    I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, eac…
    Accepted
    61 11
    Accepted Answer 61 views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Is there a function to have google sheets and smartsheet to have a live active link?
    In Formulas and Functions
    My company currently has two separate department that uses two different systems. My department is using Smartsheet and the other department is using Google Sheets. Is there a way for the two systems to communicate with each other with lin…
    Accepted
    21 1
    Accepted Answer 21 views 1 comment Most recent by David Tutwiler Formulas and Functions
  • VLOOKUP returning #INVALID REF
    In Formulas and Functions
    I am receiving the #INVALID REF error in smartsheet and I am not sure how to correct it. =VLOOKUP([PART NUMBER]1, [PN]1:[PART DESCRIPTION]1800, {2,3,4,5}, false) Below is the excel sheet formula that does work but does not flow over to th…
    Accepted
    101 14
    Accepted Answer 101 views 14 comments Most recent by Paul Newcome Formulas and Functions
  • API Demo: Creating a Formatted and Printable View of a Row
    In API & Developers
    Here is a demonstration of a feature I created using SmartSheet's API. Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here…
    1396 10
    1.4K views 10 comments Most recent by Sarah Sting API & Developers
  • Sync Google Sheets & Smartsheets
    In Using Smartsheet
    Hello, I have a task board in smartsheet that my team uses to track work.  We have a third part application we use to track metrics and it only integrates with google sheets.  Not smartsheet.  Is there a way to have smartsheet data sync to…
    344 4
    344 views 4 comments Most recent by JeremiahHorstick Using Smartsheet
  • Importing from Excel to Smartsheet (Grid) using names for contacts
    In Formulas and Functions
    I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would lik…
    Accepted
    82 10
    Accepted Answer 82 views 10 comments Most recent by Genevieve P. Formulas and Functions
  • 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…
    403 6
    403 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
    12 1
    Answered - Pending Review 12 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
    101 1
    Answered - Pending Review 101 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