First we need to import an Excel spreadsheet into Smartsheet. Along with the data, formatting, calculations and formulas, so that it works correctly. Could anyone help with ideas, help materials?
Are you asking how to make a Smartsheet grid sheet which looks up values from other Smartsheet grid sheets? If so, that's a pretty open question. Much of the answer to that depends on your particular data and your goals for the lookups.
Regarding importing from Excel:
Data comes through pretty well for the most part. Smartsheet asks if you want the first row in the Excel sheet to be used for column names, and let's you pick the Primary Column.
Formatting is hit-or-miss. A column I shaded grey in Excel came over shaded, but only shaded on blank cells. Text I had changed to red in Excel came over red in Smartsheet, but cells I had formatted to bold did not come over bold. A data column I formatted to be currency came over as currency, but a calculated value I formatted as currency did not import as currency.
Calculations & formulas: Formulas that are practically the same between Excel and Smartsheet will import. Here I calculate widget qty times widget price:
However, here where I had to use CONCAT to add FirstName and LastName with a blank space between them, Smartsheet couldn't make it work:
The Smartsheet formula to do this is easier anyhow:
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Yes, it would basically be making a Smartsheet grid sheet that looks up values from other Smartsheet grid sheets. With a main dashboard that would be a reference for the user to consult the spreadsheet data
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.