Manufacturing

Discussion List

• 
  Publishing sheet in that defaults to Card View

  [email protected] 24 views 4 comments 0 points Most recent by Jeff Range 03/10/20Using Smartsheet
  First post 11/28/18,Last post 03/10/20
  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 Smartsheet244
  [email protected]
• 
  Filter defaultAccepted Answer

  Accepted Answer Jroeder 251 views 7 comments 0 points Most recent by Andrée Starå 03/06/20Using Smartsheet
  First post 05/11/18,Last post 03/06/20
  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 Smartsheet2517
  Jroeder
• 
  Notify an assignee that the predecessor has complete his task.

  Alexander Wirtz 127 views 4 comments 2 points Most recent by Brett Shapiro 02/27/20Formulas and Functions
  First post 03/26/19,Last post 02/27/20
  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 Functions1274
  Alexander Wirtz
• 
  Calendar App / Contact Lists

  Kyle Morgan 37 views 5 comments 0 points Most recent by Francine Haman 02/27/20Premium Apps and Integrations
  First post 12/10/18,Last post 02/27/20
  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 Integrations375
  Kyle Morgan
• 
  Can I hide predecessor lines in a gantt chart?

  Project User 150 views 3 comments 0 points Most recent by Anthony Gonsalves 02/25/20Using Smartsheet
  First post 03/07/19,Last post 02/25/20
  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 Smartsheet1503
  Project User
• 
  How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells

  EmilyH 207 views 22 comments 0 points Most recent by Paul Newcome 02/24/20Formulas and Functions
  First post 09/11/19,Last post 02/24/20
  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 Functions20722
  EmilyH
• 
  Track time an item was open (active)

  Steve S 54 views 16 comments 0 points Most recent by Paul Newcome 02/21/20Using Smartsheet
  First post 04/23/19,Last post 02/21/20
  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 Smartsheet5416
  Steve S
• 
  Vlookup Limitation?

  Vivien Chong 91 views 5 comments 0 points Most recent by Genevieve P 02/17/20Formulas and Functions
  First post 11/19/19,Last post 02/17/20
  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 Functions915
  Vivien Chong
• 
  Forms that need to incorporate multiple line entries

  TrevorM 109 views 17 comments 0 points Most recent by Andrée Starå 02/14/20Formulas and Functions
  First post 11/27/19,Last post 02/14/20
  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 Functions10917
  TrevorM
• 
  Formula to check a box when date entered + 2 days

  dplunkett79331 44 views 17 comments 0 points Most recent by Paul Newcome 01/31/20Formulas and Functions
  First post 09/09/19,Last post 01/31/20
  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 Functions4417
  dplunkett79331
• 
  Fail to reset passowrd because of no response to the challenge CAPTCHA

  hlu3680451 70 views 6 comments 1 point Most recent by Just Jean 01/30/20Using Smartsheet
  First post 03/01/19,Last post 01/30/20
  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 Smartsheet706
  hlu3680451
• 
  Does Smartsheet have a way of showing hours spent working within the account?Accepted Answer

  Accepted Answer lisarae723 25 views 4 comments 0 points Most recent by Andrée Starå 01/27/20Using Smartsheet
  First post 01/24/20,Last post 01/27/20
  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 Smartsheet254
  lisarae723
• 
  Objectives and Key Results - OKR's

  brettwad 659 views 15 comments 0 points Most recent by Adrian Breitfeld 01/23/20Using Smartsheet
  First post 01/13/18,Last post 01/23/20
  Does anyone have a template or know of an existing template that could be used for OKR's?
  Using Smartsheet65915
  brettwad
• 
  Wrong Date Showing, Seems to be 4 hours off the difference between GMT and my Time Zone.

  darryl.barkhouse37731 289 views 7 comments 0 points Most recent by Bengs 12/31/19Using Smartsheet
  First post 02/13/18,Last post 12/31/19
  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 Smartsheet2897
  darryl.barkhouse37731
• 
  Resource Loading

  Katherine F 26 views 2 comments 0 points Most recent by AmandaM 12/31/19Using Smartsheet
  First post 06/12/19,Last post 12/31/19
  Hello - The manufacturing site I work at uses Smartsheet to track site priorities.  I would like to do resource loading analysis, similar to the functionality that is available in Microsoft Project.  However, to do that all resources must …
  Using Smartsheet262
  Katherine F
• 
  Notification

  Thibault P 37 views 3 comments 0 points Most recent by Andrée Starå 12/20/19Using Smartsheet
  First post 11/19/19,Last post 12/20/19
  Hi,     I have an action plan with an action column, a delay column, a referent column, and a progress column. I would like to create a workflow that sends a notification (mail) to the referent of the action 3 days before the date ente…
  Using Smartsheet373
  Thibault P
• 
  Attachments & Proofing

  mozetto 51 views 3 comments 0 points Most recent by Andrée Starå 12/20/19Using Smartsheet
  First post 11/21/19,Last post 12/20/19
  Hello, To proof I have to first upload a file, but what if the file had already been attached to the row; is there a way that an attached file can be automatically moved into proofing. Thanks
  Using Smartsheet513
  mozetto
• 
  System Column - Last Modified

  lisarae723 61 views 6 comments 0 points Most recent by Andrée Starå 12/08/19Formulas and Functions
  First post 12/04/19,Last post 12/08/19
  Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"  Here's …
  Formulas and Functions616
  lisarae723
• 
  Sorting sheets in a workspace

  Jason Reckelhoff 35 views 1 comment 0 points Most recent by Andrée Starå 12/08/19Using Smartsheet
  First post 12/05/19,Last post 12/08/19
  As of this morning, I have found that Smartsheet is defaulting my sort order to Name.  I can change to Last Update on a specific workspace, but when I click into another workspace, it defaults back to sorting by Name.  Previously, the sort…
  Using Smartsheet351
  Jason Reckelhoff
• 
  Volunteer Allocation

  KDub618 50 views 2 comments 0 points Most recent by Paul Newcome 12/05/19Formulas and Functions
  First post 12/04/19,Last post 12/05/19
  Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
  Formulas and Functions502
  KDub618
• 
  Seeing user activity as an admin

  glenn.corbin112951 44 views 4 comments 0 points Most recent by Andrée Starå 12/03/19Using Smartsheet
  First post 12/02/19,Last post 12/03/19
  I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time).  Logs only shows me logons.  I need to verify that licensed users are really using the product.   I put a tic…
  Using Smartsheet444
  glenn.corbin112951
• 
  Webform not updating after sheet changes

  alessandro.pian112971 25 views 3 comments 0 points Most recent by Andrée Starå 12/03/19Using Smartsheet
  First post 12/02/19,Last post 12/03/19
  Hello I have created a simple sheet with data for internal materials requests, including an approval loop via workflows. I then created a webform to gather input; in order to test it, in the approver / exectutor user fields I used fake d…
  Using Smartsheet253
  alessandro.pian112971
• 
  Is There Really No Built-in Log\NL Function?

  Closed Michael.Baker 55 views 2 comments 0 points Most recent by Ford 12/01/19Archived 2017 Posts
  First post 08/07/17,Last post 12/01/19
  My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
  Archived 2017 Posts552
  Michael.Baker
• 
  Unexpected movement of rows

  E Sa 24 views 4 comments 0 points Most recent by E Sa 11/27/19Using Smartsheet
  First post 11/08/19,Last post 11/27/19
  Hello, A sudden shift of rows happened while using smartsheet. The detail is as follows: Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inp…
  Using Smartsheet244
  E Sa
• 
  Trying to create a report to use on a dashboard.

  Amanda Chiancone 24 views 4 comments 0 points Most recent by Mike Wilday 11/27/19Using Smartsheet
  First post 11/19/19,Last post 11/27/19
  How do I create an 'At Risk' report, from a sheet, to include on my dashboard?
  Using Smartsheet244
  Amanda Chiancone
• 
  Can you upload multiple photo attachments from your gallery at a time?

  Lisa.stubbs112706 24 views 1 comment 0 points Most recent by Andrée Starå 11/27/19Using Smartsheet
  First post 11/27/19,Last post 11/27/19
  Is this possible, only seem to be able to add one at a time, is there a way to add multiple?
  Using Smartsheet241
  Lisa.stubbs112706
• 
  gantt chart using time as a scale

  Closed Junho Kim 42 views 5 comments 0 points Most recent by kolfinna 11/25/19Archived 2016 Posts
  First post 02/08/16,Last post 11/25/19
  I would like to apply smart sheet to my workstation for daily manufacturing status board. Is there any chance for me to change gantt chart scale from date to time.  
  Archived 2016 Posts425
  Junho Kim
• 
  Formula to flag red with multiple criteria

  FEspo 53 views 6 comments 0 points Most recent by FEspo 11/25/19Formulas and Functions
  First post 11/22/19,Last post 11/25/19
  Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally…
  Formulas and Functions536
  FEspo
• 
  Workflow or Alarm

  u.brinkrode98571 25 views 2 comments 0 points Most recent by u.brinkrode98571 11/25/19Using Smartsheet
  First post 08/02/19,Last post 11/25/19
  Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow / alarm tool. The automated mails are linked to a formular or the receiver gets …
  Using Smartsheet252
  u.brinkrode98571
• 
  What happens when I reach my 5000th row?

  Vivien Chong 27 views 3 comments 0 points Most recent by Andrée Starå 11/25/19Using Smartsheet
  First post 11/19/19,Last post 11/25/19
  May I know if there will be any alert when a sheet is reaching it's 5000th row? My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity? Thanks.
  Using Smartsheet273
  Vivien Chong