-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
Formula to change value to a number, then SUM
Hello! I am struggling with this formula & determined I need to start from the beginning. I have created a quiz. It is a mix of multiple choice (A,B,C,D) and True/False (T,F). Each letter will have a number value which is then SUM'd for a final grade. Something like this: Question 1: A=5 / B=4 / C=3 / D=2 Question 2: A=0 /…
-
How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?
I have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the project within that sheet. I'm creating a supplier sheet per project which shows all…
-
Nested IF
This seems like a pretty simple nested IF statement but it's not ever hitting the last condition. Any insight would be helpful. I'm autogenerating an Asset #. I want the formula to look at the Asset Type and if it's a "Video" insert a "V" and the autogenerated number (this works), if there is something in the Suite cell,…
-
#INVALID VALUE Error on Report but Grid shows correct result
Hi Everyone, Having an issue with my report showing #INVALID VALUE when a new submission is made on a form. I have my formulas set up in the same form where I track each row item being submitted, so unsure if this is the issue. See below: What it should display: The issue I find is when a new submission is made via the…
-
COUNT COLLECT
Hi all, I have a COUNT(COLLECT) formula that dosent seem to work. The returned value dosent match the actual number of Red Status projects under the portfolio named "X", also the column status is a symbol and not a word. In the formula i am using the refere to a spreadsheet. Help please.
-
Formula References vs Lengthy Formula Updates
I maintain a lot of large sheets - at least 9 per FY with around 190 columns and up to 1,500 rows per sheet. Within these are many transit timeline formulas for off-shore shipments. These are often in flux, and when something changes, I need to go through each sheet and update the numbers in the column formulas. This can…
-
COUNTIF Question
Hello We have a sheet that contains variations of words in a multi select column. For example; Lisa, Lisa 1, Lisa 2. I am trying to count how many times the word Lisa appears, regardless of the variation, i.e. Lisa 1 or Lisa 2. I've tried lots of different formulas but nothing is working; =COUNTM({Status Range 1}, ="Lisa",…
-
COUNTIFS ISSUE
I'm hoping someone can help. I am trying to use a COUNTIFS formula to count only if "Final Verification" is Gravoc AND "Verification %Complete" is set to 100%. I am getting stuck and it gives a result of 0. I have attached a few screen shots below. I have even tried using @cell inserts...
-
COUNTIFS Question
I have a smartsheet with MANY columns; I need to do a countif based on 3 of them. This portion works: =COUNTIFS({Quarter Created On}, "Q3", {GEO}, "AMERICAS") When I try to add this, it all falls apart: {EA 2.0 Architecture Selection}, FIND("Collab") I tried this just to see if I could get the right count of rows with…
