-
Merged: Report Summary on PDF export
This discussion has been merged.
-
Export in Workspace Panel
May 13, 2025 You can now initiate one-time exports of sheets, reports, folders, and workspaces from the Workspace Panel. These options were previously only available in Browse. This release impacts these three export options: Export to MS Excel Export to PDF Export to GSheets Learn More Environments availability:…
-
Suggestion on data import process
Hi I feel it's high time when Smartsheet should have the option to import data (from Excel / CSV) directly into the desired sheet. Further, it should automatically map the matching columns and notify about any columns that cannot be mapped. It should then allow manual mapping of columns and provide the option to import the…
-
Can I set an export schedule for every 5th WORKING day?
When sending up exporting schedules on reports or sheets, is it possible to have something go out every 5th WORKING day of the month? I see the option for every 5th day, but I know that includes weekends. Is there a way around this? Screenshot for what I am referring to:
-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Data Shuttle Export/Import
Hello, I am trying to use Data Shuttle to copy information from one column and paste it into another column by first exporting the master sheet then run an import of that export and it seems to be clearing all of my data or not uploading new data. The export currently exports all data with no filters. Below is the Import…
-
Excel Export Parameters - Data Shuttle
Hello Dear Smartsheet Community I would like to use my Smartsheet Data, to dynamically populate Email content… This being not "nicely" supported out of the box, I want to use a 3rd party app (Ablebits - Merge Email) which easily do this from Excel files pulled from "OneDrive". For this to work, I plan on upgrading to "Data…
-
Reports - When exported to PDF
When a report with groups columns exported to PDF, PDF doesn't show the report with grouped columns. It just shows a list of rows. How do I get the report what it displayed in the PDF? Don't want screen grab like solutions. Exported PDF: As you can see Project Manager, Project Name and Project Health columns (Grouped) were…
-
copy data from excel and enter into smartsheet with multiselect column
I have a report in Excel that I want to transfer regularly over into Smartsheet for dashboard reporting. One of the columns is a dropdown list that allows for multiple values. I am having trouble formatting it to where when copied from Excel, it paste into Smartsheet as the selected values. When I copy/paste, the cells…
-
Help converting Excel formula to Smartsheet
I imported an Excel file into Smartsheet, and am stuck trying to convert this Excel formula into a functioning Smartsheet one. I know some of these functions are not available in Smartsheet. However, I've tried a lot of different formulas and am still having trouble. I've even tried using ChatGPT and it's proven to be…