Here is a demonstration of a feature I created using SmartSheet's API.
Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here…
API & Developers673leejoramo
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the dat…
When 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 Smartsheet600Roy Turner
Hello, I have a task board in smartsheet that my team uses to track work. We have a third part application we use to track metrics and it only integrates with google sheets. Not smartsheet. Is there a way to have smartsheet data sync to…
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 Smartsheet94Katye Reed
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would lik…
Formulas and Functions45Kevin Smith
Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formul…
Premium Apps and Integrations126jg124
I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063.
Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no optio…
Formulas and Functions15Gurmeet Mangat
Is there a way to take a column:
I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
Formulas and Functions18Jennifer Seymour
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on ea…
Using Smartsheet36Reed Vial
We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/esti…
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 abl…
Premium Apps and Integrations27Julia Peterson
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Using Smartsheet90Improve Consulting
One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transfo…
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Formulas and Functions1096LouiseM
Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed?
Backstory: I currently have a dashboar…
Formulas and Functions38Jerome Thomas
I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I i…
Using Smartsheet75Penny Wilson
OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy docum…
Premium Apps and Integrations630Tana Perkins
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box.
We really NEED a way to save and modify the formatting of comm…
Formulas and Functions340Ezra
When I export to excel one or more Smartsheets, the exported workbook contains a "Comments" worksheet for each Smartsheet. I prefer to not have these Comments worksheets within the workbook. Is there a way to export without the…
Using Smartsheet17Nancy Hudnall
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values.
When I export the sheet data to Excel, those multiple values get combined into a single value. …
Using Smartsheet142Dave Jobling
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is m…
Using Smartsheet33Phil Schmitt
Anyone 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?
I'm trying to link my data to Power BI in order to analyse it.
Dos anyone know whether or not changing the formatting of data in Power BI would also change the format within Smartsheet?
I assume not but thought best to check first?
Premium Apps and Integrations46Scott Rae
We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs.
The dashboards are updated automatically with every changes in the master project and pro…
Hello, 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 …
When I import a csv file with a numeric column but more than half of the data is 0 or 1's, the column becomes a CheckBox column.
Less than half and it is (accurately) a Text/Number column.
Either the threshold should be much lower, or…
Using Smartsheet42J. Craig Williams
The 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 Integrations161Julie Green
Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document)
Thanks in advance,
Using Smartsheet38Scott Rae
Would it be possible to backup/export a spreadsheet on a scheduled basis more often than daily?
One of the Departments on my company asked if it would be possible to do it hourly or even every 10min, but the smallest period i can…
Using Smartsheet47Jose da Silva