-
Return a value from another sheet with multiple criteria
*IDs have been omited for privacy but there are values in the column I need to bring in the Week # values from the Master Tracker - 2026 sheet into the Week-Over-Week Modified sheet. The group and APC ID need to match. There is a potential of duplicate APC values which is why I need the group to be a criteria as well. I…
-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Formatting Issues with Index-Collect Formula
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
-
I am trying to add the number of passengers per month per year
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
-
Formula Wormhole - Count ifs distinct with multiple range requests
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
-
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
-
Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
-
SUMIFS keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
-
Finding Unique Dates
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…