-
Help with COUNTIF
Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…
-
How do I fix this formula
I need to this column to populate with the symbol from column Health if Customer Dashboard column has a checkmark. What am I doing wrong here?
-
Index Collect
Hi everyone. I need to build a sheet based on an approval matrix per function/dep code and differents amounts. I figured out how to pull data from a cell using Index Match formula to bring the Approver on my target sheet based on the cell "Function/dep code" but now I need to bring the approver based on the amount input in…
-
For a summary report
Hello, I am trying to count how many things have been completed in the past 7 days. This is my formula =COUNT([Completion Date]1:[Completion Date]50<=TODAY(-7)). The answer should be 2, but it is calculating only 1, Help and thoughts? Thanks, Ashley
-
formula to combine based on form submissions
I've built a form that asks a user to manually fill in 1 or 2 fields based on their desired job title for their email signature. Here are the choices: From the top down, let's call them options 1, 2, 3, and 4. If they choose option 2, the form logic will populate two text boxes for them. The first box will ask for which…
-
Cross Reference
Can you have some rows reference one column in a sheet and other rows reference a different column in the same sheet? It seems like I am getting a message that when I reference a column all 1000+ cells are changed to that reference, but I have 26 rows I want to point to a different column. Do I have to relocate them to…
-
Auto assign a name to a new created row (using a changeable list)
In short, new rows are add to a sheet using a form, these currently get manually picked by the team and they assigned them selves that job. However, due to cherry picking I want the system to auto allocate that new row to a name. As the team changes daily, I want the auto name to be chosen from the names of the people who…
-
Date Tracking
I need to track dates based on the milestone change. But i'd like to keep this in a separate sheet, but also include other key columns in order to create report. Example: Sheet 1 contains all data, Customer, ID, Milestones (drop down menu: received, submitted, etc.) Sheet 2 - need Customer, ID, and date that the milestone…
-
Find no duplicate on another sheet
I'm stumped. I have a column called "code" on two sheets. I'm trying to flag the rows on sheet 1 if the code isn't found on sheet two. I feel like it should be simple but I keep getting error messages.
-
Calculate expiration date
Dependencies are off. How do I calculate an expiration date from two cells below: Contract term in months (drop down menu 12, 24, 36, 60) Contract begin date Need calculation is Contract Expire Date Thank you!