This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …
Formulas and Functions62scott.barrett
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'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 Functions138Shanelle
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board.
The requirement: Show me the oldest Bill of Lading number that does not have a status of &…
Formulas and Functions34JReisman27
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula …
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 Smartsheet336Project User
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…
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
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 Integrations98cmondo
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 Smartsheet56Russ 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 Functions251Alexander Wirtz
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 Functions172Roger
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 Integrations127Soccerrick10
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 Integrations66Kyle 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 Functions129Anna 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 Functions266aalang103696
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 Functions67Clive 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 Smartsheet203Melissa 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 Smartsheet60LEO 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 Integrations62Kyle Morgan
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 Functions290EmilyH
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 Smartsheet83Steve 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 Functions198Vivien 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 Functions128TrevorM
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