-
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?
-
Why is my Excel exported from a report empty?
Hello, I am trying to solve an issue I am having with exporting data from a report to an Excel sheet. We have a financial report that is exported to Excel on a weekly basis. This week when our employee went to create an Excel export of this report, the excel had no data and only showed header names. I tried exporting this…
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Merged: Date Format
This discussion has been merged.
-
Copy/Move data that is 1 line item into new sheet as multiple line items
Help! I have been racking my brain trying to make this work, so not sure if this is even possible. Sorry if this is a bit confusing... After initial input into the form (with multiple required entries per line) I need to move the data into a sperate sheet (for excel export - to later be imported into PowerBi) as individual…
-
How to create health columns individually in a dash board ? using donut chart or Pie chart?
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?
-
I Cant seem to get my gif work on a smartsheet dashboard
I like the design of the smart sheet PMO dashboard setup(link below) and attempted to design a replica for my solution but have not been able to figure out the gif part. After converting my video to a GIF and ensuring that the size is below 30 MB I attach it to the dashboard but it doesn't animate. how can I go about this…
-
Drag-and-drop attached files
Hi there. The problem is that recently I can't drag-and-drop attached files from smartsheet to the desktop. Please, anyone, know how to solve such a problem? And the second problem of how to turn back the old interface. Because what I saw today upset me. Not a convenient innovation.