-
Summary Count of Status by Assigned Person
I have been racking my brain for a bit to figure out a formula for a summary sheet that will give me a count of each status (not started, in progress, complete, at risk) by the user assigned. I am trying to pull this information from my project sheet. I have a summary count for each status but I cannot seem to add the…
-
Nesting If Statements and Dates
Hi, I am trying to create a status column that will populate a field with the parameters below: "Yes" if all of the cells in the row have "Yes" selected. "Late" if the today's date is greater than the due date and all of the cells in the row don't have "Yes" selected. Or else "No". I have tried several different formulas.…
-
How to count grandchildren rows?
Hi there! Can't count grandchildren rows. I did use COUNT (CHILDREN) in children rows and SUM(CHILDREN) in parent one. Everything I got, was 0 in parent row. Please see screenshot attached. Can you help me, please?
-
At Risk Formula
Hello! I am trying to put together a formula that flags a project 'at risk' when: Deadline is in 3 working days or les from today Status is not complete, on hold or canceled This is what I have - but my challenge is getting trying to incorporate 'workdays' to the formula. I've tried several ways and it is not working.…
-
Need help with formula using COUNTIFS and Contains
Hello, I am trying to use a formula that will count if a project type contains the word Planned and if the state (using symbols) is red. When I use the formula below, I get an "#INVALID DATA TYPE" error message. =COUNTIFS(AND({Audit&Advisory Services -Portfolio Metadat Range 1}, CONTAINS("Planned", @cell)), {Audit&Advisory…
-
Please correct Formula Examples - Contains Function
Here is a sample of a non-functional example. Technically this is a typo, and not a flaw in concept, but if the yield is zero then it is wrong irrespective of why. https://help.smartsheet.com/function/contains
-
Multiple choice Count
Hi. I have a question. I have a column name "Solution" and we have a dropdown multiselect option as column property with the following options: AVS Distributions Collections Others I want to make a count of each individual (that' is done and simple) but other if the column has multiple choices and count just as one. For…
-
Date formula not adding days
I'm trying to add "days" to a Date. The formula in the "Test" column is: =[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), "")) This is the error that I'm getting. I'm not sure what I'm doing wrong.
-
Countifs with multiple criteria
Hi, I'm trying to count rows from another cell that meet the following criteria: In Progress In a specific Department The Project Manager cell is not blank I've figured out the formula for the first two, but I'm stuck trying to add the Not Blank part. Below, Range 3 is my Department, Range 2 is the status, and Range 1 is…
-
Sum a Multi Select Dropdown
I'm looking for the formula I would need to use if I have a multi select dropdown with numbers and words. I would only be looking to sum up the numbers. Some of the cells have numbers and words in the same cell. Any help would be appreciated! Thanks, Eva