Importing and Exporting
Discussion List
-
How to Use VLOOKUP and SUMIFSIn Formulas and FunctionsI 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…
-
Is there a function to have google sheets and smartsheet to have a live active link?In Formulas and FunctionsMy 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…
-
VLOOKUP returning #INVALID REFIn Formulas and FunctionsI 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…
-
API Demo: Creating a Formatted and Printable View of a RowIn API & DevelopersHere 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…
-
Sync Google Sheets & SmartsheetsIn Using SmartsheetHello, 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…
-
Importing from Excel to Smartsheet (Grid) using names for contactsIn Formulas and FunctionsI 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…
-
Data Uploader FilteringIn Apps, Integrations, and Add OnsHi 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…
-
Converting 2020-05-20T12:38:08.063 to a date formatIn Formulas and FunctionsHi 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
last, first to [email protected]In Formulas and FunctionsIs 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 views 1 comment 0 points Most recent by Jason Tarpinian Formulas and Functions
-
Form Dropdown HelpIn Using SmartsheetI 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…
