-
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 & Developers673
leejoramo
-
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…
Using Smartsheet217
Lboud
-
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 Smartsheet600
Roy 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…
Using Smartsheet173
cyndi2403
-
Hello 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 Smartsheet94
Katye 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 Functions45
Kevin Smith
-
Hi All,
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 Integrations126
jg124
-
Hi Everyone,
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 Functions15
Gurmeet Mangat
-
Is there a way to take a column:
Last, First
and build
[email protected]
Scenario:
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 Functions18
Jennifer 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 Smartsheet36
Reed Vial
-
Good afternoon
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…
Using Smartsheet225
BESP10
-
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 Integrations27
Julia Peterson
-
Hi,
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.
Lauren
Using Smartsheet90
Improve 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…
Using Smartsheet433
E_Pieper
-
Hi,
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"
Basicall…
Formulas and Functions1096
LouiseM
-
Hello All,
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 Functions38
Jerome 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 Smartsheet75
Penny 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 Integrations630
Tana 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 Functions340
Ezra
-
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 Smartsheet17
Nancy 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 Smartsheet142
Dave 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 Smartsheet33
Phil 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?
(Image)
Using Smartsheet41
Mattias
-
Hi,
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?
Che…
Premium Apps and Integrations46
Scott Rae
-
Hello,
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…
Using Smartsheet48
Cyril_H
-
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 …
Using Smartsheet203
NSAN
-
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 Smartsheet42
J. 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 Integrations161
Julie Green
-
Hi,
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,
Scott
Using Smartsheet38
Scott Rae
-
Hi all,
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 Smartsheet47
Jose da Silva
