-
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 Smartsheet55
Improve Consulting
-
Now that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a secu…
Using Smartsheet107
saltyblueocean
-
I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to:
1. Clone the work flow from one worksheet to another
or
2. print the work flow so i can enter the same verbiage & flow in all the sh…
Using Smartsheet285
beth_linder28141
-
Hi All,
I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushin…
Premium Apps and Integrations80
cmondo
-
My notification emails are now coming across with a colored background. Is there a way to turn this off in SmartSheet so that I don't have to do it when I forward my emails?
(Image)
Using Smartsheet42
Russ Anderson
-
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions213
Alexander Wirtz
-
Hello,
I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.
https://us.v-cdn.net/6031209/uploads/737/K88X8…
Formulas and Functions60
Shanelle
-
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
Using Smartsheet64
Shah_0614
-
Hello,
First of all thanks for helping :)
I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations.
My Milestones are "locked", colored in blue and in this case identified…
Formulas and Functions136
Roger
-
For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neith…
Premium Apps and Integrations109
Soccerrick10
-
Smartsheet,
Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the …
Premium Apps and Integrations52
Kyle Morgan
-
HI,
I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue??
Please see attached excel with formula in Column D
Thank you …
Formulas and Functions110
Anna Mullins
-
I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the for…
Formulas and Functions197
aalang103696
-
Hello - I am new to Smartsheet, so I have A LOT to learn! (Image)
Since attachments are not stored locally in Smartsheet, I need to save files requiring updates in OneDrive. Rather than maintaining OneDrive access separately, is there …
Using Smartsheet96
lynn.vanpelt37356
-
Basically what im trying to do is a project tracker. When the guys do a project they spend a certain amount of hours on it. thats all good until the project is paused and restarted again i have a issue where it calculates off the closest d…
Formulas and Functions65
Clive Wallace
-
I'm hoping the smartsheet Gods can help me.
I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink)
I'm trying to count projects by…
Using Smartsheet181
Melissa Shoumlisky
-
In Request Tracker, How can I change the default value of department and Request type? How can I put the department and request type in this form?
Using Smartsheet45
LEO LIANG
-
I have a sheet published in Card View on our company Wiki page with Read Only - Full features.
I'd like to have the ability to set the Published Card View to match how I have my sheet set up and not a generic Card View.
For example, I h…
Using Smartsheet26
[email protected]
-
Is there a way to save a filter as the default. I want the same filter applied every time the sheet is opened without the need to select it.
Using Smartsheet412
Jroeder
-
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App?
We have a calendar that references an existin…
Premium Apps and Integrations54
Kyle Morgan
-
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
Using Smartsheet260
Project User
-
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions262
EmilyH
-
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ?
…
Using Smartsheet75
Steve S
-
Hi I would like to understand about this limitation in vlookup:
* Each sheet can include no more than 100 distinct cross-sheet references.
* There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet …
Formulas and Functions156
Vivien Chong
-
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible
As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
Formulas and Functions115
TrevorM
-
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row.
For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours…
Formulas and Functions43
dplunkett79331
-
Hi,
I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request…
Using Smartsheet110
hlu3680451
-
I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sh…
Using Smartsheet33
lisarae723
-
Does anyone have a template or know of an existing template that could be used for OKR's?
Using Smartsheet929
brettwad
-
As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the…
Using Smartsheet475
darryl.barkhouse37731
