-
Salesforce Imports Apostrophes
This is a public service announcement... If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe. The apostrophe will not appear until you click in the cell. You can rid of it with a helper…
-
Why do rows collapse when I print?
Hi, I'm trying to print / export a standard grid sheet. When I do so, the rows collapse and I cannot see anything. Does anyone know how to fix this so I can see all of the rows on my sheet? Thanks!
-
Importing an Excel Workbook
How can I import all the sheets in an Excel workbook at one time?
-
How can we export all smartsheets in our environment at once?
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
-
Is there a simple way to automate the "Export to Microsoft Excel" on a schedule?
I'd like to download the Excel versions of multiple Smartsheet sheets on a weekly basis to a location on my local machine. Is there a way to do this easily?
-
I have an excel sheet with at least 4 tabs, and i want to transition that over to Smartsheets
qqqCan anyone assist me in how i can do this, i know smartsheets doesnt include tabs. Below i will give an example. How can i make this reflect in Smartsheets, and as i get new associates, I would need to match them up to a shift? I hope that make sense. any assistance would help, thansk in advance.
-
Data offload to an existing excel file
Hi, How can I offload data from a Smartsheet grid to an existing excel sheet? I merely want to add on data, and am not looking for a new sheet to be created. Any ideas?
-
Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead…
-
Excel Import Yielding Strange Formatting Results
So I have an issue where when I import an Excel workbook with only one sheet and no formulas the cells with text in them come in with a white font color and a black fill. I tried the advice (disable all extensions) found in another post about a similar issue with a form's font color and it still is coming in that way. I am…
-
Sum from Report
I know this has been asked but it's been a while so maybe there's been a change 😀. Is there a way to do any of the following? Use data shuttle or some sort of automation to export a report to a sheet in Smartsheet or to a Google Sheet? Use sum formula on a sheet from a workspace? (so that I can sum all project plans within…
