-
SUMIF Not Working
Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages in the red square under the column "Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is…
-
Change Management: Multiple projects > Consolidate into one
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way to organize them without listing them all out and clogging the other non-change…
-
IF formula for earliest date
Hi Community, Could anyone please help with this formula syntax? I want to capture what is the earliest date within a date range for a specific role, "Production" in this case. =IF(Role:Role, "Production", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), "") It…
-
Need help with 'If , Then' function to subtract Duration Values
I'm setting up a Construction Schedule with Variance calculations as the 'Near Term' baseline solution that's been quoted as coming for a few years now has not materialized yet. Unfortunately after searching the forums I'm not seeing syntax examples that work for what I need to do. It would be helpful for me at least to…
-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
-
I.T. Project Management workflow process
Hello, I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk drives. I have information on an excel sheet that was provided & an initial Smartsheet…
-
Smartsheet Form Multi Entry
Hi All, Just have a query regarding Smartsheet forms. I am currently setting up a form to track consumables for a project. The project may have up to 20/ 30 different consumables associated with it. Is it possible to use a multi-select dropdown for the user to enter these consumables which in turn will enter the required…
-
Is it possible to set up your own template sets?
Hello everyone! 👋 I've created a workspace for a project which includes multiple sheets, reports and dashboards which all link together. It's something I've put a good bit of work into for a while! Is it possible to use this as a template set for other projects? As far as I can see, I can only create a template from a…
-
SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned. =SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed]) However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to…
-
Auto-Populate Left Stub for Schedules
Thanks to Paul Newcome, I was able to get a WBS schedule working. Now I need to create several schedules, using the WBS as the left two columns. Here is the problem - I need for all schedules to update whenever a row is added or deleted from the original WBS sheet. Simply using Cell Linking does not achieve this. Here is…
