Formulas
Discussion List
- 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 2…
- 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…
- 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, St…
- 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.
- 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 tha…
- 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 "blocke…
- 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, Multi…
- 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 su…
- 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 st…
- 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 …
