-
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…
-
Checking a box using an OR statement
Hello, I'm trying to check a box if either of these are true: Data Upload Status = Operational Data Upload Status = 1st Upload Done I'm using this formula but getting an "Incorrect Argument Set" error: =IF(OR([Data Upload Status]@row = "Operational", [Data Upload Status]@row = "1st HydraCor Upload Done", 1)) Thanks for…
-
Date or N/A in a cell
I am trying to figure out a column formula that will auto-populate a cell with either a date or an N/A: N/A, if the [TOTAL BUDGET] cell is under $100,000 or =[Final Report Due]@row + 15 if the [TOTAL BUDGET] cell@row is $100,000 or more (this would be the audit report due date) I tried this but it's not quite working:…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…