-
Input data into sheet from a document
I love the function of taking data from Smartsheet and generating a pdf. Is there a way to reverse that functionality? For example, this format is easier to work with in a team setting: But I would like it to be uploaded to feed information back to the sheet in Smartsheet: Thank you for consideration.
-
Can a report be directly exported from a WorkApp?
Can a report be directly exported from a WorkApp?
-
Managing Cross Sheet References at the Workspace Level
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…
-
Grouping causes "name" to not show in export
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…
-
Merged: Define A Column as either a String or a Number
This discussion has been merged.
-
Moving data from one sheet to another - nothing works! VLOOKUP, INDEX MATCH, INDEX COLLECT
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…
-
Why does Smartsheet add a single quote before an integer that begins with 0?
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…
-
Automatically fill a sheet from a pdf or word doc
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…
-
Sheet Summary Report - Exports in Completely Random Order
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…
-
Exporting Smartsheet into Excel and Rendering Checkboxes
Can Smartsheet do something on their end so that checkboxes "checked" in Smartsheet don't render as "TRUE" after exporting the sheet into Excel?