-
Cross reference match formula
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start Time End Time There could be multiple Slot Numbers so it would need to be a multi option that I could use later to separate…
-
What formula do I use for my needs?
I have 2 sheets (see screenshots) and what I need is to have the Associate Name from the Associate List sheet copied to a column in the Permissions sheet but only if certain criteria is meet. If there is a date in the Yard Access AND GTDR Expiration columns, I need the Associate name listed in the GTDR Certified column on…
-
Multiple nested IF(AND) paired with INDEX/MATCH ? or other way ?
Hello to everyone. Im starting to go deeper into advanced formulas and sheet reference, but have some issue... I have a "customer activity" sheet, where for each line, there is 2 sets of variables (5 in "activity", 3 in "types"...) and a "Duration" column. I would like to compute the "Final Price", by referencing a "price…
-
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…