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 Smartsheet55Improve 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…
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
2. print the work flow so i can enter the same verbiage & flow in all the sh…
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 Integrations80cmondo
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?
Using Smartsheet42Russ 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 Functions213Alexander Wirtz
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.
Formulas and Functions60Shanelle
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…
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 Functions136Roger
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 Integrations109Soccerrick10
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 Integrations52Kyle Morgan
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 Functions110Anna 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 Functions197aalang103696
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 …
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 Functions65Clive 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 Smartsheet181Melissa 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 Smartsheet45LEO 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.
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 Integrations54Kyle 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 Smartsheet260Project 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 Functions262EmilyH
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 Smartsheet75Steve 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 Functions156Vivien 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 Functions115TrevorM
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 Functions43dplunkett79331
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…
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…
Does anyone have a template or know of an existing template that could be used for OKR's?
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…