Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Importing and Exporting
Discussion List
-
First post 05/21/18,Last post 01/24/20Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…API & Developers164adgcz -
First post 06/13/18,Last post 01/09/20The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example,…Premium Apps and Integrations463Julie Green -
First post 06/22/18,Last post 01/02/20When I import my MS project files into smartsheet it appears to lose information and change some of my start and finish dates. I have project but others in my company use smartsheet to view the schedules but the dates they are seeing are d…Using Smartsheet524Roy Turner
-
First post 11/13/19,Last post 12/12/19I am having an issue where my hyperlinks are not exporting to excel. This is something I have been using for months and just noticed it not working today. Is there a setting that has changed?Using Smartsheet274chris.young111116
-
First post 12/05/19,Last post 12/05/19Hi, this is my first time posting. Hopefully this is not a duplicate of another posting. I just ran into a problem this morning with "What you see is what you get" is not consistent in exporting a document. I have a roll-up doc…Using Smartsheet181hopek
-
First post 08/12/15,Last post 12/05/19I find that I can only select columns I want to put to PDF if i have gantt charts on. I want to export a nice PDF w/o a chart yet still select columns. I would like to be able to MANUALLY determine the width of columns in a print pr…Archived 2015 Posts272DavidS
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions402KDub618
-
First post 12/04/19,Last post 12/04/19Hello - I have published reports to a dashboard that my clients can go and check. However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel. Is there…Using Smartsheet241Andy_DAI
-
First post 12/02/19,Last post 12/02/19Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this? (Image)Using Smartsheet211Mattias
-
First post 11/23/19,Last post 11/27/19Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been …Using Smartsheet262JDupes -
First post 11/26/19,Last post 11/26/19I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…Formulas and Functions341bukkymoh01
-
First post 11/20/19,Last post 11/25/19I am trying to export my smartsheet to excel and whenever I do this, all the hyperlinks are gone and I have to enter the hyperlinks again manually in the generated excel spreadsheet. I tried exporting to google docs and the same issue. Hyp…Using Smartsheet222vjateafxdotcom
-
First post 11/19/19,Last post 11/22/19I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …Formulas and Functions533Serena Williams -
First post 11/19/19,Last post 11/20/19Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?Premium Apps and Integrations401Jwindels
-
First post 11/15/19,Last post 11/16/19Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking prin…Using Smartsheet181egobuty
-
First post 11/07/19,Last post 11/15/19While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to …Formulas and Functions325austinurbanSeagate -
First post 11/08/19,Last post 11/13/19Hi There, When I export schedule from Smartsheet to XML file and open XML file in Microsoft project, the dates of some tasks got moved. Has anybody had the same problems and possible ways to fix it? Dale DaiUsing Smartsheet131Datouyu
-
First post 11/12/19,Last post 11/13/19Hello All, Is anyone aware of a way to export proofing comments and markup? Currently, I have to take screen shots of the file and the comments to compare with the previous version and use for archiving purposes. Thanks for the assis…Using Smartsheet215Katye Reed -
First post 11/07/19,Last post 11/13/19Hello, 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 …Using Smartsheet252NSAN
-
First post 10/30/19,Last post 10/31/19Hey Guys, Unsure if this has been raised before but I am trying to export a report to PDF and include an image currently added to a cell in the original sheet. If I export the sheet I can see the image but not when exporting the report. …Using Smartsheet263ClovisSS
-
First post 10/29/19,Last post 10/31/19If Smartsheet only imports the first sheet in a workbook, why does it care how many other sheets there are?? (Image)Using Smartsheet111smichelson
-
First post 06/11/18,Last post 10/30/19Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly…Using Smartsheet899Nathiele
-
Jörg Schmidt Novum Hospitality 21 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 10/15/19,Last post 10/28/19Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until …Using Smartsheet214Jörg Schmidt Novum Hospitality
-
First post 04/27/16,Last post 10/24/19Does anyone know how to merge two sheets into one seamlessly to include all attachments and discussions please? Thanks in advance, AndyArchived 2016 Posts1365Andy Ross
-
steve.estoque72076 15 views 1 comment 0 points Most recent by Nathan Lloyd Premium Apps and IntegrationsFirst post 10/17/19,Last post 10/21/19I have a need where I need 3 different Smartsheet form fields to be concatenated into a single JIRA field. For example I would want these 4 from My Smartsheet fields: * Description of Request * Expected results * Why is this info needed …Premium Apps and Integrations151steve.estoque72076
-
First post 10/17/19,Last post 10/21/19I get this error every time trying to import Trello into Smarthseet. "An error occurred while importing from Atlassian Trello." Any ideas what is causing this error and how I can get this import to work? (Image)Using Smartsheet237imyers107961
-
Closed Rachel Bontrager 27 views 10 comments 0 points Most recent by steve.estoque72076 Archived 2017 PostsFirst post 01/11/17,Last post 10/18/19We are using a smartsheet to populate a jira project. basically, a user fills out the webform, it updates the sheet, and then we push that into jira. The first issue I'm having is attachments. Is there a way to attach the attachment…Archived 2017 Posts2710Rachel Bontrager
-
First post 10/18/19,Last post 10/18/19Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to s…Using Smartsheet212beatea
-
First post 10/18/19,Last post 10/18/19It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid s…Formulas and Functions191beatea
-
Closed Andrea Hall 23 views 6 comments 0 points Most recent by Stephen D van der Werf Archived 2017 PostsFirst post 07/05/17,Last post 10/17/19Is there a way to export the Activity Log once filtered? We would be able to use this for our metrics. It would be a huge time saver and really make SmartSheet that much better for us! I am sure this could be used in this manner for other …Archived 2017 Posts236Andrea Hall
