-
SUMIF Budget when priority does not equal x
I've tried to review this older post (among others) to see if I could figure out why my formula was not working. But was unable to sort out why. Trying to SUM a budget column if the Priority column does NOT equal "N/O" =SUMIF([Priority]:[Priority] <> "N/O"), [Budget]:[Budget]) =SUMIF([Budget]:[Budget], Priority:Priority <>…
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
SUMIF Help
I am trying to write a formula to add up a range of cells but only add up the first and the last of the cells that show a numerical value. So in the 3rd row it would add the 21 in the Monday and the 21 in the Wednesday column , in the 8th row it would add the 18 in the Tuesday column and the 18 in the Wednesday column, in…
-
How to write a formula that checks a box automatically.
Hello, I am having issues creating a formula for my sheet to check a box if all cells have been added. Each team member collects and copies the answers to the "master" sheet. I want a box checked when they have added their responses that can flow into a report. Thanks!
-
How do I fix my Corrective Actions ID number to count only the ancestors created under the status?
As of right now I have this as my formula =IF(COUNT(ANCESTORS(Status@row)) < 1, "", YEAR([Date Generated]@row, 2) - 2000 + "-" + IF(COUNTIF(Status@row, Status@row) < 10, "000" + COUNTIF(Status@row, Status@row), IF(COUNTIF(Status@row, Status@row) < 100, "00" + COUNTIF(Status@row, Status@row), IF(COUNTIF(Status@row,…
-
add 7 days to a date
I need to add 7 days to a date, but not in a date column as i need to have a formula below for weeks increasing. the date needs to be Australian format i.e day/month/year.
-
Parent row in report
Hi i have a sheet with ~2000 rows and ~1200 tasks. each task is assigned to worker. the worker need to see only the culomn that i choose in report and update only one checkbox column. the issue is that i want to display to worker the parent rows... and in report i not assigned the worker in parent row.... ony the specific…
-
Help with a formula!
I have been using this formula in various sheets to have a specific date pulled, depending on if a certain field is blank or not. It has been working fine, but all the sudden is now throwing a "blocked, circular dependency error." Any help is greatly appreciated. Attempting to check if the revised due date column is blank,…
-
Should be simple I thought
I have tried what I thought should be a simple formula two or three different ways. Here is the basis of the requirement. Multiple Months, Multiple Vendors with multiple invoices within a month, Multiple projects that some of the vendors bill to and others do not. For the purpose of this exercise, I need to get the invoice…
-
Numerical Values (Points) for Dropdown Fields and totaling the Numerical Values
Hi, I am working on a sheet where I have 6 fields that require the user to select a value. Each field's value will have a numerical (points) equivalent. I have created the 6 dropdown fields and was successfully able to build a "helper" column next to each, using an IF statement to populate the Helper column with a…