-
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…
-
How to match clinical trials to subjects based on eligibility criteria columns?
Hello, I have 2 sheets and I want to pull information from sheet to another sheet if certain criteria are met. The first sheet, "Slot List", is a list of clinical trials and the columns contain the study name and certain eligibility criteria patients need to meet to join the study. On the second sheet, "Trial Match", is a…
