-
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…
-
Count number of times a value appears?
I 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 a column, that would track the amount of times a report pulls a machine name. I.E. if Machine…
-
Formula if cell is blank then, if cell is not blank then....
Formula 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 then Yellow, if days open is >=90 then Red. I can write the individual formulas to get the red…
-
% Complete based on Todays date, Start and End dates
I'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 column so I can keep dependencies on the actual % complete column) =(MIN(TODAY(),*finish…
-
Reference Codes
Hi, 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, is there a way to make this a rolling serial number as each update request is…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Please add a successor column or function
A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A successor column allows one to simply filter to find the missing successors. Thanks.…
-
% Complete staying 0
Good Afternoon, I am new to Smartsheet, and am having trouble with what seems to be a simple task. The parent % complete will not change from 0%, no matter what I put in the child's information. Thanks.
-
Find the row with the earliest Created (Entered) date that matches certain criteria
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of "Closed" or "Canceled." In another cell, show me the full Created date and time of that…
-
Report on all sheets I am part of as Assigned To
Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that…
