-
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…
-
If 2 Criteria Met On Second Sheet, Display ID Number from Second Sheet on First Sheet
I am trying to write a cross-sheet formula in sheet 1 (field name is Row ID) to display the Row ID from a second sheet if the second sheet Newest field and ED field are both checked (see below). I've been looking through posts and attempting INDEX/MATCH, nested IFs, etc. and nothing is working so far. Any help would be…
-
Sum last n rows
Does anyone know how to write a formula that will sum up the last four rows only? Example- The GPO Volume dollar amount gets populated each quarter. I would like a formula that would remove row 11 and add in row 15 once the value is in there so I can only show the last 4 quarters total volume. Thanks in advance!
