-
Training Registration - Specific date for each department
I need to create a training registration form wherein I would like registrants from each department to select the same date. Each department gets a date. I have already thought about having a liaison choose a preferable date for the department, but I would like to know if there are any other ideas out there on how this can…
-
Count of At Risk
In my sheet summary, I'd like to get a count of "At Risk" flags. What am I missing from this formula? To add, if possible, I'd only like to count the CHILDREN (not the parents) =COUNTIF(CHILDREN([At Risk]:[At Risk]))
-
Auto Number Column is Being Copied Over From New Rows
I have a row ID setup with auto numbering on a totals sheets that contains all the copied rows from multiple projects. When the copied rows are inputted into the total sheets (using automation) the row ID is then updated with the row ID from the other sheets. I use this auto number field to identify duplicate rows (and in…
-
INDEX(COLLECT( )) where some rows are blank
Hello Community! I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet. The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with…
-
#UNPARSEABLE with multiple IF statements
Hi, I am trying to create TEXT depending on some conditional information. I want to display text RED if my materials clear date is less than 7 days from my due and display text YELLOW if my materials clear date is less than 14 days (but greater than 7 days) and if my materials clear date is greater than 15 days, leave the…
-
How to Apply formula to dropdown columns
Production Status- drop down column- with values like In-Production, Production Ineligible etc Handoff Column-dropdown column- with values 1,0, N/A Contract Signed -Dropdown column-with values 1,0, N/A Need a formula that if for "Production Status"-Production Ineligible is selected from the dropdown then Handoff column and…
-
FORMULA HELP? max/collect/if
I am trying to get information from another sheetA to sheetB I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏 Please bear in mind new rows…
-
Tenure - Years and Months Formula - help!
Hi All! I know there have been many posts re: figuring out tenure, but I am super new to spreadsheets and some of the community posts keep losing me with the round ups, @rows etc, I was wondering if someone might be able to explain with my own row examples - how to get years and months of tenure using 1. Start Date and 2.…
-
Return line's value based on multiple criteria
Hello, I am looking for help in returning a particular cell's contents based on multiple criteria. I have two sheets I am working with, Primary Sheet and Data Sheet, where I will be searching for the criteria. Below is a snippet of some dummy data. I would like to write a formula where I return the value of the Work ID…
-
If/And/OR to give Status based on 2 Variables.
Hi Folks, Working on an If/AND/OR thing that I can't seem to work through. Which is frustrating because it's rather straightforward. If Col 1, and Col 1 are both "No" then I want to output "Open" into the Status Column. If Col 1, and Col 2 are both "Yes" then I want to output "Closed" into the Status Column If Col 1, and…
