-
Counting Checkboxes for Children
Getting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I don't need to worry if the formula is capturing the new rows.
-
Amount of Requests per Lawyer
Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols") This is what I have right now (changing name for…
-
Update Date when Health Changes
Hi All, I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask: "When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the change occured" Simply, we need a way to automatically track what day the change in health…
-
Formula to show if certain cells are blank change the status to red, yellow, or green
I have a sheet where we want to show if the columns successor 1, 2, and 3 are blank the status column should be red. If only successor 1 is filled out status should be yellow If successor 1 and 2 are filled out staus should also be yellow If all 3 successor columns are filled out the status should be green. Pretty much…
-
Indicating Each Month A Project Is Active?
Community, I'm struggling to indicate which months a project is active given a project start and end date. If a project starts on 09 January 2020 and ends on 09 March 2020, it would be active January, February, March. I would like to represent this as follows: Showing that the project was active in its Start Month and End…
-
Populate a cell with all corresponding values in a multi-select drop down cell
Hello, I have a column in my sheet that is populated by a multi-select drop down in a form ("Violation" column below). Once submitted, the cells in this row will contain at least one, but typically multiple entries from the multi-select drop down. Once submitted, I would like two other cells to populate with the…
-
VLookUp Inconsistently Pulling Data
I have a sheet with multiple triggers. Form populates row and assigns a Row ID Client receives a request to update info on that row Once completed, a user is notified to print out the responses for distribution I had to create a work around because there is not a way to nicely print out individual rows Used the VLookUp…
-
Formula to Look Up Multiple Contact Columns
Hi There! I am creating a formula that will assign contacts to a row based on user role plus some other attributes. I am finding the look up is working great for assigning 1 contact, but when I extend the formula to include multiple v-look ups, its displaying the 2 users names as text. For example it will come back…
-
Countifs syntax killing me
I want to count number of projects on hold AND change control = resource constraints This is what I"ve tried; =COUNTIFs([Portfolio Rollups Range 8], "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")
-
How do i write a formula to calculate YTD totals of a given category
Here is the formula i started with. It gives me a #unparceable response =SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY())) Ive included a screen shot