-
COUNTIFS Function - 0-30, 31-60, 61-90, >90 Days
Hi, I am looking to pull the total number of unassigned projects with 0-30, 31-60, 61-90, >90 Days. The "Completed" column is the date the form is submitted. I am getting a value of 0 when using the formula below. Thoughts? =COUNTIFS(Status:Status, "Unassigned", Completed:Completed, AND(@cell >= TODAY(), @cell <=…
-
Vlookup to find result in child row
Hi all I am after help on a formula to pull in information from another smartsheet using vlookup but at the child level. I am looking for a match in my project to Ref, which is 699 and then find the data within the child row from Task 01. In this case, the result would be DC The reason for this is that we need to create a…
-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Cells not multiplying correctly.
Hi, I have two adjoining cells that are not multiplying correctly. I have tried =[part qty] * [module type] and the formula returns "10" when it should return "20" I have tried =[part qty]@row 8 [module type]@row and the formula return "10" when it should return "20" Any help would be greatly appreciated. [Module Type} is…
-
Children Status Nested in IF statement with Checkboxes
Hello, I feel like this is a simple problem but for some reason I keep getting "#INVALID OPERATION". I would like to have the formula look at the children rows and if any box is checked then check the parent row box, otherwise leave it unchecked. I came up with : =IF(CHILDREN() = 1, 1, 0). That gave me #UNPARSEABLE. So…
-
Trying to accurately gather % complete based on statuses and excluding N/A in children rows
Hi all! I am revamping a project task list template that my team uses each time we are building a new location. We'd like a high level completion status for each department involved in these projects, but I'm running into a bit of a hiccup with my formula. In the Status column of the departmental parent rows, I am using…
-
Count Specific Instance Within Prior Month
Hello, I am trying to get the number of instances on my 2021 Archive sheet where the "RFI Reason" was equal to "ADCVD". I've tried the following formula but it is giving me the count of all items from last month, not specifically those that have a RFI Reason of ADCVD from last month. Any assistance would be greatly…
-
Checkbox cross referencing person on another sheet
I am looking for a formula to cross check another sheet to check a box on my cumulative sheet. Example, someone completes a required training on EM# 1 sheet then on the EM# 2 sheet I want that persons name to be checked from a list of other individuals. This is the formula I used, =IF({Emergency Preparedness Employee…
-
Summary Formula to Show New Value Each Day
I have a sheet that tracks new employees by type. Within my sheet, I have a date column and employee type columns (example: Intern). I'd like to create a Summary formula within the sheet that will return the number of interns each day. Or a formula that will return the last entry in that column. How can I do that?
-
Cross Reference Countif Formula is giving Unparsable Error.
I am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31)) However, when I modify on another sheet to read as what is…