-
How do I count for something that has not already been used in a cell from a multi cell dropdown?
Hi all, I need help! From this list of machines, I would like to know which machines are available on a particular day.. I have a date column on my sheet. How would I solve this? Much appreciated!! Thank you!
-
MAX function -most recent date
I know this should work, but it's not. I am referencing other sheets and pulling in the max date. I am getting an unparseable in return. What am I missing? If I put just one "HOUDATE" it's invalid. yes - I am pulling from Date column types. Thanks!!
-
Adding a date range to COUNTIFS
Hello, I need to add a date range to a rollup I created for tracking sales meetings: =COUNTIFS({source sheet customer name}, $[Primary Column]@row, {source sheet dropdown result}, [In Person Meeting]$1) The above works, but is obviously counting the whole sheet, which includes 2 years of data. I tried: =COUNTIFS({source…
-
Systems columns
Hi, I have a form that gathers data. The team works on it and rows change status. Once a row changes to approved, I'd like to move it off to another sheet but my automation is giving me an error - sheet you are moving data too has a systems column of the same name as your original sheet. I have deleted my created by/date,…
-
IFERROR and INDEX/MATCH formula with criteria?
I am using this formula currently on a work document (slightly modified): =IFERROR(INDEX({Assigned Specialist}, MATCH([Project Name]@row, {Project Title}, 0)), "") Now, what I would like to add is a criteria to this formula that checks the other sheet (the same sheet that Assigned Specialist is on) to see if the Project…
-
Adding at risk based on health color
I'm trying to make a formula to set a flag in the at risk column based on whether the health is red and at least 3 days past the due date. Something isn't behaving quite right on the 3 days part and it's flagging some things that are not yet 3 days past due.... Here is what I have, is this not correct? =IF(AND((Health@row…
-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
-
Show all Children Health Ball Colors in Parent Cell?
Here's an example, if there are 3 children with different health statuses (see ss below). Is there any way to show all three colors in the parent field? Thanks!
-
Using a VLOOKUP and IF statement to return different values based on two different columns
Hi, I'm so sorry if this kind of question has been asked in the community forum but I've been trying to comb the questions but haven't had any true luck yet. Currently I used a VLOOKUP function to populate a personnel contact column based on a particular project column. That part is working correctly. However, recently I…
-
Parent Flagging based on Child Rows
Hello, I'm working in a project planning trying to highlight if a specific row, or project, has any task as children that is at risk. Does any syntax support this function?