-
Flash-fill a column similar to Ctrl+E function in excel
I am looking for a solution similar to the Ctrl+E flash-fill feature in Excel, or a formula to extract just what I need into another column for export. For example, I need a column that has information set up like "101 - Class Listing" to have a column lined up next to it that has the "101" extracted (all in the same row).
-
COUNTIFS using different sheet for range and month for criteria
I am attempting to get this formula in my tracker sheet to work to count all the instances in the reference sheet where a certain month in the date column occurs and the answer to a question in another column is no. This is the formula I have come up with and I know it's wrong but all of the fixes I have attempted have not…
-
automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made…
-
Auto filling a cell based on the entry in another cell
Hi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form just on my sheet when the entry has been submitted. Sorry i am really struggling with this and fear it is around Vlook up…
-
index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
-
Formula to check the Unit availability
I would like to check the Unit availability, we want to check the start date & end date and U1, U2, U3, etc. and unit availability column should provide whether it's available/nonavailable to use for other projects Is there any formula that can do this? Also when a unit is assigned for a particular project for a particular…
-
Quick question about creating an IFERROR statement after an OR statement
Hey everyone, Hopefully this is an easy question, though I'm having a hard time figuring this out! I'm trying to write a COUNTIFS statement that can be broken down into quarterly segments. I learned that an OR statement would allow me to include multiple months in the statement, but now I don't know how to properly include…
-
Verification IF Formula
I am trying to create a verification IF formula that will check two cells and they need to both be true to output "Good" or false "Verify". I making this to find errors more easily in forms they are filling out. We have them putting incorrect packaging for production lines that can't make that product. (Yes I could logic…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
=IF([End Date]@row,>=TODAY,"Yes", "no")
Trying to tabulate in process Items.. I want it to toggle YES if the end date is past today and No if the end date has not been reached--- from there I want to sum the "Yes" values I have to break this up by quarter so also was going to start with each item by date then add an additional for Quarter so... If Q1 and Date is…
