-
Sumifs or Countifs
Trying to figure out the formula to solve for the following: If Column A = "Bob" or "Frank" , and if Column B = "Blue" , then count Column C's #. Basically trying to figure out how many blues Bob and Frank have based on the Qty in Column C. I need to exclude everything that doesn't meet those requirements. Example: Column…
-
Adding IF condition Formula
Good morning, I'm struggling with the syntax for the following formula where I'm trying to include a WHERE condition that looks for an active status. The formula works great until I introduce the WHERE condition to the point I've just thrown my hands up. My status flag condition is either 'Active' or 'Not Active', or…
-
Include a form field with no option to fill in info?
Hi all, Is it possible to include a field in a form with no option for the user to fill in? For example, if someone selects something, I just want to give them an instruction, not have them provide any information. Here is the specific scenario: Is this budgeted for? Yes/No If No, then display text: Please confirm a budget…
-
Is there a best practice formula to use for this scenario?
I'm attempting to grab the value circled below on a daily basis and feed into in a master spreadsheet. I'm using a MAX formula in the latest record to help me capture the relevant record. It would feed into this spot in my other spreadsheet My thought is to do a formula to say if latest record is checked, grab value in…
-
Percentage Complete Function
Can someone help me with the formula/function for this - looking to put it on a metric sheet for the dashboard to pull from: 6 tasks (Taks A-F) divided by Comple from Status column to get percentage of project done.
-
How can I set a Row ID column that does not change when you move, add or delete rows
Hi all - I've been able to create a Row ID column that updates when you add/delete a row fairly well, but when rows are moved around it breaks again. Current set up: X: autonumber column Row ID: =MATCH(X@row, X:X, 0) This works ok but every time I move rows or make big changes I have to re-set the autonumber (X) column. I…
-
Webform Woes
We are using a Webform for "Check In" and "Check Out" but only the "Check Out" captures the "Installation Status". Each "GVRID" has 1 of each. We need the "Check In" "Installation Status" to match what is entered during "Check Out" for the same GVRID. The Webform is a source sheet and feeds a master via "INDEX MATCH".…
-
COUNTSIFS does not Contain
Hello, I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below. =COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary})) The formula works until…
-
Creating WBS formula for deliverables spread out over phases
I have a project schedule that is organized by phases. Tasks for each deliverable are spread throughout the phases. The team has requested we add a WBS ID to the project schedule so we can identify/track the work across the phases. I'm trying to create a formula to generate the WBS. My formula to create the WBS Phase - 0…
-
Formula calculate last 30 days referenced sheets
=SUMIFS({Sales Pipeline Amount}, {Sales Pipeline Level}, "1", {Sales Pipeline Start}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))) + SUMIFS({Archive Sales Amount}, {Archive Sales Level 1}, "1", {Archive Sales Start}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()),…
