-
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…
-
Sheet Template : When copying a template, my formula's don't migrate.
I'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a template or otherwise, I always have to figure out the formulas again. Is there a way…
-
Automated Copy / Move rows between sheets - just copy some columns
Dear all, I'm a project manager and recently started using Smartsheet. I'm trying to configure an intake-prioritization and approval process for all the projects requested by our users. I have my main sheet called it : Project Requested 2021 then I created another sheet for the projects approved by the Board: Project…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
