-
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…
-
Auto-check checkbox upon import?
Hi, I have a Smartsheet sheet that is fed by Formstack submissions. I added a checkbox to a column - how do I auto-check that checkbox on all imported rows? Some background: this sheet feeds into a report along with several other sheets. All the rows on this sheet are from one district, and I want to note on the report…
-
Control resoultion for export Gantt to image
The current export Gantt to image tool is useless because the resolution is so low that text is unreadable. Please either up the image resolution, or (preferably) provide us with a slider to adjust the image resolution setting. Thanks.
-
Dynamic View won't let us choose a drop down item in the details panel
I have a dropdown list of a few statuses that I added to our details panel. It worked yesterday but now isn't. An error populated once that says 'you have invalid changes. Please review and try again' but now that doesn't populate- it just won't save.
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
