-
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
-
JOIN checkboxes and text cells into one new column
Currently my formula is set up to show me text based off what cells are checked. I need to add to this formula so it will show me checked cells AND a text cell, combined. I've tried expanding the range to include Toys and that did not work. Any suggestions? Current formula for the EquipmentHelper column:…
-
CONTAINS COUNTIFS from Multi-Select Drop-Down
Hello, I've had this issue before, but forget how I've solved it. I have a formula that is trying to count an option in a multi-select menu, it cannot be a simply COUNTIFS statement and must use CONTAINS or HAS since there is more text in the cell then just one word. Here is my formula, which is appears the syntax is…