-
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
-
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:…
