-
How to use vLookup for other sheets
Hello, I've been trying to use vlookup to find data from a datasheet Sheet A contains a column 1 with "My Name". Sheet B contains column 1 with "Name" and "Number" I want a column in sheet A that looks for the corresponding name in sheet B and returns its number. I've looked up tutorials on this but there doesn't appear to…
-
How to compare 2 sheets and harvest data from one sheet onto the second sheet
I am comparing 2 versions of a product BOM(one is flat, and the other is organized by sub assemblies and lists critical components). Each BOM is stored in its own Smartsheet Grid. One BOM has vendor and vendor part number information. I want to harvest the vendor and vendor part information from one of the BOMs and insert…
-
What formulae touse to get the count of status of A In Progress/Not Started and the same for B
-
Odd way to emulate excel formula counta()
Needed to count all cells for a project, found how to do it, and am posting it here in case it helps someone else. on range a =countifs(A:A,@cell = @cell)
-
COUNTIFS Errors
I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = "Yes", @cell =…
-
#unparseable error when creating a symbol formula
Hi, I am trying to create a formula to return a status symbol based on the date on a cell. Basically, I have a column called "Date PRF Received" and I want to put a formula in the next column to show a Red light if the date is prior to today's date and Green if the day is still in the future. I am using the formula:…
-
INDEX MATCH showing #NO MATCH when there is one
I am trying to reference another sheet. The column I am trying to match is the Primary column that has hyperlinks and I am trying to match the display text. Here is my formula =INDEX({Project Intake Sheet Range 1}, MATCH(Links@row, {Project Intake Sheet Range 5}, 0)) Range 1 is the primary column for the display text of…
-
Index(Collect with multiple criteria
I'm trying to make a formula in a sheet summary that checks if the "duration" column is not blank and then uses all rows that arent blank as a range to then find the row with the newest "created" date and return a value from a different "IndexKey" column. I'm not sure if i need to use an IF staement to limit the range or…
-
Progression chart
Hi everyone, I have a questionnaire solution that only reports the latest attempt to answer it. It records how we as an organisation are doing against ICO Guidelines. My manager has asked me to create a dashboard that shows progress. So a line chart that will show how the organisation is progressing. My problem is the…
-
Check if Item is Available based on dates input
This may be an odd one.. Backstory: We are attempting to replace a check in/check out feature we have for our internal associates to reserve items from our Marketing Team for tradeshows or other events. The workflow is; the user would look up an item (I have implemented an item inventory number for a unique identifier)…