-
Why won't Index and Match column formulas work past row 1 on destination sheet?
I'm working on developing a PMO solution and have started with the suggested intake and portfolio metadata sheets. I have set up Index and Match formulas to pull information from the intake sheet into the metadata sheet and they worked beautifully for the first row of data. However, when I entered a few additional test…
-
Multi-Line Chart from Imported Excel Data based on Counts Per Date
Hello! Got a problem that's confusing me because I'm used to Excel and can't find a way to do this on SmartSheets. Context: I have a CSV that I export from a database that contains info about design issues such as ID #, Status, Create on Date, Updated on Date. I'm using Smartsheets as a project management tool and I'm…
-
Is there a way to pull cells that meet criteria into individual cells in another sheet?
I'm working on a multi-sheet solution for my PMO and have been using Index and Match to pull specific information from a metadata sheet into matching cells on other sheet using INDEX/MATCH. I've been using either the Change Order (CO)number or the Scope Change ID (Larger Project Identifier) for most of the solution, but…
-
Some parts of the automation not running based on Index(Match) cell change
Hi folks, Could I get some help with this issue, please? Published sheets shared below. Workflow: Order Form Sheet - lists items (Primary column), has a Submit check box column (box is checked), and has a status dropdown column with an INDEX(MATCH) formula referencing the Tracking Sheet. Rows are locked. Tracking Sheet -…
-
'Cleaning' Zoom Attendance Names to use Index/Collect
(We cannot use Zapier Integration). So, I created a Data Shuttle to pull the information from the Zoom attendance report. However, I need to Index/Collect how we designate the entity that they are associated with based on the person that attended, and we don't get the emails of outside parties from the meeting. People's…
-
Index match on multiple sheets
Apologies if this question has been asked, I wasnt sure how to search for this within the community. I stumbled across this formula using the AI formula builder which sort works but not sure how to fix it, its when the simple formulas start stacking is when im getting lost in how they work together. What I have is an…
-
INDEX MATCH Formula
Hi, I used this formula in one column on Sheet 1, it looks at Sheet 2 and finds the Site Name and if the Status is Committed, it pulls in the number of Committed Trees. It works just fine for the Committed Trees column. =IF(INDEX({Inventory Agreements - Status}, MATCH([Site Name]@row, {Inventory - Site Name}, 0)) =…
-
IF Row @ Column A=Column B, then return Column C
I have 2 sheets. Sheet A to track the orders: Order IDs (column 1) and the Services (column 2) of those Order IDs. Sheet B to track the hours works on the orders: Order IDs (column X) and the Services (column Z) of those Order IDs. I am trying to use a formula that says: If Sheet A Order ID@row equals Order ID@column A on…
-
How do I import an entire column from one sheet to another without getting #unparseable
I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this? This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)" We're gotten "=INDEX({A. Wash Schedule Range 1},…
-
Trying to get a list of distinct values across multiple columns based on multiple criteria
Hi, I am trying to list all the distinct values for the Year 1 through Year 4 columns but only for the rows the WBS row value is equal to WBS Target value and skip any blank cells. I have a helper column to index up to 10 distinct values (Screen shot below) Any help is greatly appreciated!