-
effort and allocation-based timelines?
We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencies, effort in hours, priorities, plug in the resources and set their allocation, and…
-
Count number of resources per project
Hi, I'm trying to count number of resources assigned to a project but I'm not sure how to go about it, when there is a duplicate. Meaning, if John Doe is assigned to 5 tasks, Jane Doe is assigned to 3 tasks, and Billy Bob is assigned to 1 task, is there a way to count the number of resources assigned to the project, which…
-
Calculating Count of Projects by PM by Month
Hi, Trying to create formula to calculate How many projects start in a certain month by each Project Manager - My excel formulas are weak Master sheet has columns: Project Manager is Contact List (does this have to be a Text/Number Column?) Project Start Date - is Date type Column =COUNTIFS({Keller Project Summary - MASTER…
-
Formula for finding the first and last days of a year
I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?
-
Feature Request - Cell History Graph
For all of my projects I need to track the overall % complete for the project and individual areas. I currently have Smartsheet calculating this information and displaying as a % in a cell, but I would like to be able to show how the % complete has trended over time. Is there a way to show the individual cell history as a…
-
Sum ifs 3 criteria
I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the rest =SUMIF(@{Collections Range 3}, @cell = "Green", {Collections Range 1}) This information will be…
-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
-
Dynamic Views- Wrap Text?
Hi, I created a dynamic view for the first time today, but can't seem to get the text on column headers to wrap in the view; I didn't see any option for adjusting the column width either. Any ideas on how to do this? Thanks!
-
If forumula
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30