-
How to use IF/AND/CONTAINS formulas with multiple sheets
Hello, I am having a bit of difficulty expanding an IF formula to include a value that is in another column. Let me give an example https://app.smartsheet.com/workspaces/GJqhP3jxmV78WQfw4mc3c6PXH3WqPJcjM2c3Frh1 In this mock workspace I have created basically what I'm doing and what I would like to happen. (all names and ID…
-
Index/Match in different scenarios on same sheet
So far I've been successfully working with index/match to pull certain names (PM/Supervisor, Additional CC) when a certain requester is used on a sheet. Now I have a requester that is assigned to two (2) different clients, but the PM/Supervisor and Additional CC are different people per client. How can I incorporate that…
-
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…