Can a report be directly exported from a WorkApp?
Today, cross sheet references must be managed within an individual sheet. I'd like to be able to implement and manage cross sheet references at the workspace level as well. Use Case: 3 sheets containing unique data, but identical columns that are fully replaced weekly; 2 reports generated from those 3 sheets. The 2 reports…
I have a report that pulls participants under various managers. Each manager has their own report, and the report is sorted/grouped by employee (see image 1 below). The problem I am having is when I export the report in excel or PDF- it doesn't show any names unnder the employee column (see image 2 below). I can't figure…
This discussion has been merged.
Hi Community! Hoping one of you might know what I'm doing wrong here. I'm trying to bring data from my source sheet (a list of requests) into a target sheet (list of placements). I've created a reference ID that exists in both sheets (KP Placement ID) that is an auto-generated number in the source sheet. It's manually…
A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered). Example: 099999999 changes to ‘99999999…
I have researched that currently we cannot export to pdf or excel in the grouping format that it shows in the Report. I have noticed that this has been discussed and mentioned for a few years but little information or anything to suggest it is actually being worked on. When will this be updated/timeline? As I unfortunately…
I'm wanting to do a review to make sure I have everyone placed in the right buckets. I can dump a user list but there's no group membership details included. I don't see any automated way of dumping group members to CSV for review. The best solution i found is stupid -- open each group and copy-paste the html into excel…
I have a word form that one of our teams needs to fill out. They then send me a pdf of the form and I need to enter the data from the form into a Smartsheet log. Is there a way to automatically scan the pdf and enter the data? I can also do it from the word form if needed. Creating the form in Smartsheet directly is not an…
Hi - I have created a sheet summary report, in which the projects are sorted by a completion date. When exporting to PDF, the order is completely random and has 0 logical sense, not matching any other order that would exist. Not sure why the export can't match the sort input, or why grouping doesn't even matter when…
