Manufacturing
Discussion List
-
Creating training CalendarIn Formulas and FunctionsHi All, I am currently trying to create a sheet to track who our trainers are currently working with. Currently have 15 trainers, but the team will grow larger in the next few months. Each trainer can train 2 employees at a given time. Emp…
-
TimestampingIn Formulas and FunctionsHello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Help with Trend DataIn Formulas and FunctionsI need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. …
-
Automatic Predecessor AdjustmentIn Formulas and FunctionsHey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
-
Best Method to Track Resource Loading by Individual & Their List of TasksIn Using SmartsheetHello, I work in manufacturing and have used Smartsheet in the past and taken advantage of the "issues/task" list template for a specific capital project and modified to fit my needs. It worked great. I set up a very simple dashb…
-
Count number of times a value appears?In Using SmartsheetI have a sheet for tracking the amount of defects that occur. Each defect report has a "Machine Name" value which is selected via a dropdown. What I'm trying to achieve is to have a counter, in any form but preferably a widget or…
-
Formula if cell is blank then, if cell is not blank then....In Formulas and FunctionsFormula gods, looking for help, please. I'm trying to write a formula that says if the finish date is not blank, then the QA status is Green, if finish date is blank, then go to the days open field and if less than >= 60 and <=89 th…
-
% Complete based on Todays date, Start and End datesIn Formulas and FunctionsI'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17/7 and ends on the 31/7, and today is the 24/7 - the % complete would be 53%. - (I want to have this as a separate colu…
-
Excel ImportIn Using SmartsheetWhat are the prerequisites for importing an Excel spreadsheet into a new sheet. I read number of columns, size and row constraints, which my Excel spreadsheet meets. I am getting a warning regarding fields cannot be more than 50 characte…Answered - Pending Review 399 views 4 comments 0 points Most recent by Madalyn Nelson Using Smartsheet
-
Reference CodesIn Formulas and FunctionsHi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out…Answered - Pending Review 12 views 2 comments 0 points Most recent by bvannuland Formulas and Functions
