-
Overall Average Percent Compete
Hi All, I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0,…
-
Excel Import
What 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 characters long. Is this regarding the primary column only or is this for all columns?
-
Dynamic Production Date Schedule
I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring forward the manufacturing dates, there are many occasions…
-
IF OR ISBLANK Help!
Good afternoon, I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value. The two cells will never both have a value in at the same time, just one or the other. The cells are as follows:…
-
How can I link two forms from two different sheets to put the answers on one singular sheet?
I want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible? If so, could you help?
-
Notifications to Company Managed Distribution Lists
Now that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a security feature my company has or an issue with smartsheet. Our company distribution…
-
Populating a Smartsheet from an Oracle SQL DB
We use a smartsheet to track the progress of investigations on my site. The investigation ID, description, etc. are stored on an Oracle SQL DB and I'd like to autopopulate the smartsheet with the relevant fields. Is there a way to do this? I tried Power Automate but my organization does not currently support the Smartsheet…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
Creating training Calendar
Hi 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. Employees are trained for 2 weeks. Ideally, I would like a form that someone can request…
-
Best Method to Track Resource Loading by Individual & Their List of Tasks
Hello, 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 dashboard to show status of tasks, # of tasks assigned to each person, etc. However, that was for…
