-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Projectā¦
-
Comparing names from Worksheet A to Worksheet B and Identifying those on A that are missing from B
I have two worksheets. Worksheet A is the master Worksheet B is a collection of months' worth of data-it is populated by a form. I'm trying to write a formula where I compare Names from Worksheet A to Worksheet B and identify on Worksheet A names that are missing from B in the current month. Worksheet B has a column thatā¦
-
Form Submission / Vlookup Integration
Is there a mechanism to achieve either of the following scenarios: Individual populates form and choose a serial # from a drop down list. Can the fields on the form then use vlookup to auto populate the equipment's location from a master grid sheet on the form prior to submission? OR Individual populates form and choose aā¦
-
Cross-reference sheets to find matches
Hi! I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if aā¦
-
Basic Logic in Forms - Not working
Hi all, Im setting up a form, and what should be quite simple doesnt seem to be working for a logic request. I have a question midway through the form, if the user selects the anser 'Yes' from the dropdown (field A), a field appears to answer (Field B). If its a no, then the field stays hidden and move on to the nextā¦
-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to workā¦any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Formula for Multiple same names count once AND single name counted as well
I used this formula from another community post which counts a person's name only once if it appears multiple times in the column. However, it does not count a person's name at all if the name only appears one time and I need it to. In the example below, how can I get it to count Doe, John as one AND Mouse, Mickey as oneā¦
-
Inventory Grid
Hello, I have built a sheet to track stock/item quantities. I am wanting to show a live count of stock levels. I have used two separate columns for the item quantity so the people handling the stock can use a mobile device form to enter the data. I have also created a report to show the in and out sum of each item, but iā¦
-
Formula Issue: Sum of column based on data in two other columns argument error
Hello, I am running into an "incorrect argument" result. I have a sheet and am using data from another sheet to pull information and add it together. I am trying to reference three columns in the first sheet: column one is total cost, two is fiscal quarter (Q1, Q2, Q3, Q4) and three is last name. My goal is to total in theā¦
-
Formula for Tracking
Hi everyone, I'm struggling with creating a formula to track the progress for my project. So I have created status for each activitie which need to be done. However, I don't know how to link them and turn into % of completed progress. I will attach the image below. For example: When Venue Booking is Done. The % ofā¦