-
Using data shuttle for weekly backups from smartsheet to sharepoint
I have successfully turned on the weekly export from smartsheet to sharepoint, but the action is "replace". I don't want to replace my file each week, I want a series of dated weekly backups for an audit trail. Is this possible?
-
Any recommendations for conversation export with a project to Excel
Hello, I am exporting a project that has a WBS column and would like to include the conversation. This currently exports to a separate tab in Excel but there is a disconnect between the reference conversation line item and the first tab where the row information exports. It typically shows one row off from the actual…
-
Some dates importing incorrectly through Data Shuttle
I am uploading data onto Smartsheet through Data Shuttle from a CSV file. I have a date column and have confirmed most dates are importing correctly, however there are instances where the day and month are swapped. i.e. the date on the CSV file reads 12/04/24 (DD/MM/YY), but is added to the Smartsheet as 04/12/24. I've…
-
Image as map input
Hello, Is it possible to use an image as a map to either click to input coordinates as x and y values or to plot the coordinates back onto the image? I've done lots of searching but can't find anything. I want this feature to mark locations on a site plan or equipment drawing. Not a Google map. AppSheet does something…
-
how can i import the data in existing sheet
I'have two sheet both sheets have same columns, i want to import both of them as a single sheet in smartsheet. can anyone help me how can i do this Thank you Mayur
-
How to Export or Save Filters with a Published Smartsheet Plan
Hi Smartsheet Community, We have a published version of our plan, but when someone tries to export or save the plan, none of the available or created filters are included in the export. Is there a way to enable the export or saving of filters along with the plan? If not, does anyone know of a workaround that would allow us…
-
Unable to import an Excel or .csv file into Smartsheet
Hello, I have a file which was exported from a sql server and converted to an .xlsx file. The file only has one tab and contains 12K records. I am unable to import the file into an existing workspace in Smartsheet; upon first attempt, I can select the file, then select the primary column, but then the Smartsheet 'import'…
-
Export selected rows only to excel
Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows. Alternatively, is it possible to do a mailmerge via word…
-
Reduce the size of the exported schedule with gantt
I often deal with quite extended schedules (more than 1000rows). Exported pdf size is huge (for 1000rows schedule it can be around 50Mb). For example the same schedule exported in MS Project will have 20 times smaller size. It creates a lot of inconvenience when providing the schedule to the customer. Would be good if…
-
Export Excel sheet and email as attachment workflow
Hello, Is it possible to create a workflow where it exports the data to excel and emails excel as an attachment to an email?