-
Automatic Notification in Form Entry
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…
-
Merged: Specific column with cell history
This discussion has been merged.
-
Cell view history
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
-
How to add multiple costs from dropdown menu items
Hello, I am struggling to identify a formula that can read multiple selections in a drop down column, find the corresponding selections and prices on another sheet, and return a total cost. The sheet supports samples that are analytically tested. The user chooses which tests they want to conduct for each sample on the…
-
Mirror Row
I have a list of employees on one sheet. Can I have that column mirrored to another sheet so changes are made in real time and I don't have to update two sheets?
-
Merged: Enter Form information on existing row
This discussion has been merged.
-
Idea funnel
Hi all, I'm at a manufacturing company. I am looking into a Smartsheet solution for idea generation and management. These could be cost improvements or reach into new product development. We would likely have project goals (improve margin, expand sales, ect), ideas (that need to link to SKU's and goals) and gather input on…
-
Filter per user
I already submitted the request several years ago, but we would like to have a sheet with filters that are available only to certain users. For example: the “Bryan” filter would display only the rows containing the “Bryan” department, and only he would be able to access that filter. Another filter could be available to two…
-
updating predecessor automatically
Hi, if I add a new row above an existing row which has a predecessor, does Smartsheet automatically update the predecessor number ?
-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I am…
-
Dependency columns: Automations or Formulas in Start / Finish & Duration Columns
With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine schedules. We are utilizing Smartsheet to build out our schedule the production and forecast the completion of our products. All…
-
Inventory check
Help please! I have an inventory issue I need to work on. I have a production schedule where my production team adds line items for the PO they are supposed to work on. Each Line item may have the same item number, and could have the same quantity. I am using data shuttle to pull in my available inventory. From there I am…
-
2 sheets for daily production and production schedule for a PO (month) =Status
I have two sheets. One sheet for tracking daily production and another sheet that tracks the production for the month. I have a status column that matches on both sheets. On the production schedule I have that status of the reference number. If production is working on that reference number it has a status of Work in…
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
-
Has anyone used Smartsheet for production resource scheduling?
My company is still relatively new to Smartsheet. We have a project template that is working well for us. However, we also would like to also find a way to use Smartsheet to help us plan/schedule our production resources. We want to be able to line up projects, machine hours, and labor (non smartsheet users) so that when a…
-
How to Identify Duplicate Job Numbers on Multiple Sheets?
I manage 30 production projects across three Smartsheet sheets: one main sheet (Project Management) and two spin-off sheets (for Ordering and Install Certification tracking after a project ships). All sheets use a unique 4-digit job number for each project. What’s a formula or function I can use to quickly identify if any…
-
Submission checklist to reference production schedule
Good morning, I have 2 Sheets Master Production Schedule - consists of multiple columns, Job #, Job Name, Line 2 Count, Forms Submitted?, and Status Check List Submission - consists of multiple columns, Job #, Job Name, Line 2 Count, Submitted, Outstanding Entries, Missing Form Override(Checkbox), and Status The idea is…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…