-
Another #NO MATCH problem
Some entries match, and some don't, making it complicated. So here we go. I am attaching screenshots. Here is the reference "table" Then, here is the main table: Near Zero returns a "1" (good) Very Low returned a "3" (good) Low, Medium, and High all return "#NO MATCH" (bad) Very High returns a "1" (Bad) TIA - Tom
-
Average formula with an IF statement
I have this average formula in a sheet based on 4 columns: =AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) The results would be either 1,2,3, or 4. I'd like to translate the resulting number into text. For example, let's say my average formula…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Multiple References and Criteria INDEX/MATCH
Hello everyone, I am working to connect several sheets to create a master "Tracker" for 600+ projects used across the department. I've been able to get pretty far using INDEX/MATCH/COLLECT functions to match by project numbers (unique ID) and pull in dates and status indicators from other sheets used by specialized teams…
-
CRITICAL PATH NOT SHOWING AT ALL
THATS IT, JUST NOT WORKING.
-
Select only most recent rows using LARGE?
I thought I would post my issue here since the SS community has been so great at helping solve my other SmartSheet dilemmas! For each project that the PMO oversees, we have a sheet with a single row of project health metadata. On the first of each month a workflow runs against the metadata sheet and copies the row to a…
-
Auto Sequence by Date?
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the…
-
Using CountIFs with cross reference and multiple criteria
Hello! I am looking for some assistance on a formula. I have a Master Sheet and a Helper Sheet. I am trying to calculate the number of specific events associated with a person within a date range utilizing cross-sheet reference. I have tried multiple formulas, but not having any luck =COUNTIFS({Sample Master Type}, "New…
-
INDEX/COLLECT with Partial Text Match
Hi - I'm trying to use an Index/Collect formula to bring back information based upon two text variables that could be included in my search range. Below is the formula as I have written it and I get and Invalid Column Value error when it runs. The columns that I am pulling information from are restricted dropdown columns…
-
Sumifs w/ cross sheet references not working
Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific customer is working. =SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row)) But when try to…