-
SUMIFS trouble
I feel like I'm almost there with this, but just can't figure it out. I'm trying to determine a Sales Rate (money/hours) per Estimator, per month (date range). My column headings are: Ops Start Date, Estimator, Scope Hr, and Contract Amount. I think the problem is using a date range within a SUMIFS formula. I know its…
-
SUMIFS Multiple Criteria
I'm beating myself up. Im trying to calculate the sum of tasks, that if they have the status "Submitted" and the submitted date is in March then it would calculate the value. Currently it is saying its #unparseable =SUMIFS([Submitted ($)]:[Submitted ($)], [Status]:[Status], "Submitted", [Date Submitted]:[Date Submitted],…
-
SUMIF with dates that land in a specific month
Im trying to use the sumif function to match 2 columns of data, transaction type, and corresponding value then return only month specific dates read from a date column. Date column is in mm/dd/yy format.
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…
-
Dynamic Sum from Multiple Sheets in a Workspace
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like…
-
Count Multiple Cells If Multiple Conditions with Date
Hello! I am working on linking a database to a results sheet and I need several metrics pulled out. I have Supplier, Defect Column 1, Defect Column 2, Defect Column 3, and date. What I ultimately need to do is create a January through December count of defects per Supplier. So I have Jan, Feb, Mar, ... Dec. on one axis,…
-
Prevent users from entering dates that put other tasks in the past
Our project managers are responsible for creating new projects in our schedule. They enter a install start date and contract date. The dates for all the other tasks are formula driven from the install date. The image below shows our engineering tasks. Those 3 projects where entered within the past two days. All of our…
-
IF Function to Deliver Target
How do I build a formula with two variables to deliver a target date? Example: IF cell A = defined variable and cell B = defined variable, then cell D = 6 months from date reflected in cell C. I can do this in excel using IF and Edate functions, but can't figure out in Smartsheet. Any assistance would be greatly…
-
Need formula to count starred items from a parent row.
I'm looking to count starred children from a parent row. I'm sure there's an easy way to do it by doing a: COUNTIF(CHILDREN(.... Any help is appreciated.
-
Widget filter, IF statement, or what?
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?
