-
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 Functions11
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 Smartsheet30
Reed 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 Smartsheet489
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 Smartsheet144
cyndi2403
-
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 Smartsheet184
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 Integrations21
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 Smartsheet67
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 Smartsheet347
E_Pieper
-
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 & Developers547
leejoramo
-
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 Functions950
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 Functions31
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 Smartsheet66
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 Integrations513
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 Functions289
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 Smartsheet15
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 Smartsheet95
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 Smartsheet28
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 Smartsheet36
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 Integrations40
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 Smartsheet45
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 Smartsheet158
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 Smartsheet37
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 Integrations150
Julie Green
-
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 Integrations101
jg124
-
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 Smartsheet36
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 Smartsheet36
Jose da Silva
-
Dear Smartsheet,
The issue
- 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 & Developers47
adgcz
-
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?
Using Smartsheet21
chris.young111116
-
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…
Using Smartsheet12
hopek
-
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 Posts133
DavidS
