-
Need help with formula to automatically fill in Contact List from another column
Hello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigned to)) Sheet 2 (reference Sheet) Technician Name - Contains full name Email Address -…
-
Index and Match returns one incorrect response...all others correct
I have a service request sheet with an index/match formula to assign a person based on request type. My formula works for all request types except "External Communications" - it assigns the wrong person. I tried creating a new "Assigned To Lookup" reference sheet, manually entering all fields, and yet the error persists.…
-
Vlookup Contact List... Recognition after Save
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter…
-
How to return more than one value with multiple serach values with vlookup
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to…
-
Cell links break when adding new row. Work again when saving linked (unchanged) sheet.
Hi all, I have two sheets that are connected via multiple cell links. When adding/deleting a row in sheet1, all the cell links break (#INVALID DATA TYPE). To make the links work again I have to go into sheet2 and leave again. For some reason it saves something in sheet2 when I exit, however nothing has changed in sheet2.…
-
Counting checkbox's for children without counting the parent
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the row will be counted. My goal is to have a total count of images that we have a color version for. the URL is on a row…
-
Autopopulated customized response after form submission
I don't think this is an option, but here goes. I have a form connected to a smartsheet that references another smartsheet to autopopulate text information based on a selection in the form. Instead of someone having to either 1) go in and view the autopopulated cells, or 2) the smartsheet owner emailing the submitter the…
-
Extract Image using Index and Match/Vlookup
Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't work in SS. Additionally, I cannot do a direct link, because we are using the "store…
-
How to query data from one sheet to another?
I have a sheet which is essential reference data. I then have another sheet which will be used to actually do management with, but it needs to "pull" data from the reference sheet. VLOOKUP is only returning one data set. How do I use Smartsheet to query the reference sheet and return a list of rows which match a specific…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
