-
Index/Match using dropdown with multiple selections
Hi, I'm trying to use Index/Match to list the mission statement(s) for each selected non-profit from a dropdown that allows multiple selection. The mission statement lives on a reference sheet and I'm able to get the mission statement if only one non- profit is selected but not when multiple is selected. I thought I found…
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
Formula to populate column with value from another column
Hello, I have a helper column (Project Title) that is supposed to populate with the Project Name based on the below formula. The AI indicates that the formula is supposed to locate the cell in the column "Action Items" that contains the term "Project Name" and then populates the "Project Title" column with whatever is…
-
Copy and automatically maintain a subset of rows in a new sheet based on non-unique indication
I would like to associate costs with tasks that we have in a program plan and then create a summarized version of this in another sheet. For organizational purposes, I'd like to be able to filter (and copy) the tasks that have costs associated with them into another sheet in order to add more detail to these line items…
-
Dynamically choose column to sum/countif from a wider range?
I am working on some budget tracking. I have a source sheet with each expense account and how much is budgeted for each month (Jan-Dec) and it goes back years. I want to display the info on a graph that show Jan-Dec and the sum of all expense account budgeted amounts in each cell. Right now in my metric sheet I have the…
-
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…