-
Template recommendations for tracking product design approvals and status from design to production?
So I've been looking at Smartsheet as a solution to a project tracking problem, but I'm having a hard time finding a template for the purposes I'm intending it for. If this needs to be created from scratch, I'd love to be pointed in the direction of some resources. I work at a company where we have many products being…
-
Return Multiple Rows Using VLOOKUP and COLLECT
Good morning, I am working on a formula which will return multiple rows of data from a different sheet based on criteria. For context, I am looking to view all the cells from sheet A (defined in a range) where there is a value like "BA Edit" in sheet B. I have tried doing this several ways, with no success.…
-
Request for advice on best way to structure sheet column fields / data for reporting
Please give me your input on the best way to structure my sheet data to achieve the reporting/summary options desired. The current data is being migrated from an Excel workbook with ~20-30 column fields per row which makes it difficult to use for our project management/collaboration. But Thus far using the construction…
-
Trigger Approval Request with the submission of an Update Request
Is it possible to send an automatic Approval Request right after an automatic Update Request was filled in.
-
Find highest value and return matching column header
Hi Everyone, I have to inspect several cavities in a process by using a Smartsheet form. Then, out of this database, I would like to know the highest and lowest cavity weight along with the cavity #. I wonder how can I do that. Here is an example: If Cavity 2 has the highest value, and Cavity 1 has the lowest value. I…
-
If Children Contain then display cell on that row in Parent Cell
Have children() that vary in range, children rows can vary from 1 to ~30. For each child that contains "Action" in column [Issue Category] display the cell Notes contents into parent row Notes cell. Currently using static formula. Issue is every time a row is inserted, I have to manually add to the formula. Current formula…
-
How to estimate hours per Task using % allocation, Assigned to and Duration Columns?
Hi Everyone, I hope you all are doing alright. We need to estimate how many hours will problaby be spent on each task. We already use %allocation, Assigned to and Duration columns in our cronograms. We can't use the suggested formula "%allocation * Duration * 8" because: 1) Multiple employees can be assigned on the same…
-
Project Plan - Excluding rows from the overall completion percentage calculations
I am creating a project plan that will be used for Lifecycle maintenance programmes. Each project plan will consist of up to 8 different work packages which will have their own task lines in. (See attached pic) This basic format will be the standard for all Lifecycle programmes. One of these will be for one of the…
-
Rotate Headers to a row instead of column
I am trying to create a report from data in smartsheet, but due to the amount of info on the report it becomes very small and unreadable when converted to a 1 page 11x17 pdf sheet. I was wondering if there is a way to make the sheet rotate the column headers to row headers to allow it be printed at a larger size.
-
Filter View Access for certain users
Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specifications) into Smartsheet, which will automatically send a notification to the supplier, who…
