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 Functions11Jennifer 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 Smartsheet30Reed Vial
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 Smartsheet489Roy 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…
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 Integrations21Julia 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 Smartsheet67Improve 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…
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 & Developers547leejoramo
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 Functions950LouiseM
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 Functions31Jerome 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 Smartsheet66Penny 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 Integrations513Tana 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 Functions289Ezra
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 Smartsheet15Nancy 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 Smartsheet95Dave 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 Smartsheet28Phil 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 Integrations40Scott 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 Smartsheet37J. 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 Integrations150Julie Green
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 Integrations101jg124
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 Smartsheet36Scott 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 Smartsheet36Jose da Silva
- import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addre…
API & Developers47adgcz
I am having an issue where my hyperlinks are not exporting to excel. This is something I have been using for months and just noticed it not working today. Is there a setting that has changed?
Hi, this is my first time posting. Hopefully this is not a duplicate of another posting.
I just ran into a problem this morning with "What you see is what you get" is not consistent in exporting a document. I have a roll-up doc…
I find that I can only select columns I want to put to PDF if i have gantt charts on. I want to export a nice PDF w/o a chart yet still select columns.
I would like to be able to MANUALLY determine the width of columns in a print pr…
Archived 2015 Posts133DavidS