-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…
-
Symbol magically appears in a cell that is copied over to another sheet
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…
-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
Clock In and Out with Lunch Time Stamps
I need help creating a formula that will calculate my employees time in and out along with their lunch break.
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Como extraer la Hora de varias celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas?
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Formula not working - need help please - showing as incorrect argument
Can someone please help on the below formula - it is not working and showing as incorrect argument - I want it to take into consideration both the month and the year - if it past or later than the proposed service date then i want it to show its late via 'YES', blank if its blank and if its in date to show as N/A - the…
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
-
Isolate User Entered Value in Multi select list
I have a multi-select list that looks like the below. My goal is to map form results to a PDF and I've used helper columns to turn the responses into checkboxes [formula for those: =HAS([Indicate the type of referral source]@row, "Yes, parent")]. However….I do not have the multi-select limited to my answers so that staff…