-
Trouble with join/collect or index/match, with multiple columns and multiple results
Hello, I can't seem to get this right and after too many hours on this, I am escalating it to the formula masters of this great community once again. I am attempting to create a cell that will collect and join all the matched criteria from two different columns with the same criteria. There are multiple matches in both…
-
Collect Data and Join
Hi There I have a sheet which is populated by a form (Booking Form) where the user selects a date, and enters her/his details and the number of people, As these people select dates randomly, the Smartsheet list is not in chronological order. I have successfully created another sheet (Summary Sheet) where I use the date and…
-
Requesting help reporting top three vendors for three locations based on a common review database
Our team is trying to build a tool to intake vendor reviews based on five averaged criteria to inform vendor selection on future projects. I've built the form, a review collection database, a review metrics helper sheet, a vendor masterlist and a preliminary report. I'd like to be able to consistently report the top three…
-
Max Collect in Sheet Summary
I'm trying to have the Sheet Summary list the employee name from the Repeat Category Winner column with the highest Repeat Count per Category, and I have 3 categories that I will use this for (Timesheet Not Submitted, Timesheet Not Approved and Time Off Not Approved). Formulas for those columns in the screenshots.
-
Help with translating text values into numeric values for graphs
Hello! I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown column and each option will be a bar on the graph. I'm having a hard time separating the data first by team and then second…
-
Count IF Question - Running Count
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Name]$1:[Creative Name]@row, [Creative Name]@row) Please Note: Sheet A Creative Name = Sheet B Ad Name Sheet B is generated…
-
Index Collect or Lookup Formula Help
Good Afternoon All, Currently having trouble with an index collect formula between 2 SmartSheets. On Sheet A there are 50 Unique ID's that correspond to 50 Creative Names on Sheet A. On Sheet B I am trying to bring those 50 unique Id's over by matching back to the 50 Creative Names on Sheet A. So my formula is as such:…
-
MAX COLLECT across a range
I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my range, Forecast worksheet: Quarters For example purposes please…
-
Searching within collected values from across multiple sheets
I am having trouble coming up with a way to search within values using a Collect formula. I have three sheets, one which shows the courses a user has completed, one which shows the courses included in each learning plan {CourseMapping_Course} {CourseMapping_Paths}, and one which shows the learning paths assigned to each…
-
Finding the most recent entry
I am having issues finding the most recent update to my list of fleets. I have read about the Max(Collect()) function and don't quite get the result back that is needed. I get incorrect column value, incorrect funciton, etc. or when I have been able to get it to run I get back a 0 instead of an actual date. I have tried…