Cell linking
Discussion List
-
Need help with formula to automatically fill in Contact List from another columnIn Formulas and FunctionsHello, 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 (assigne…
-
Index and Match returns one incorrect response...all others correctIn Formulas and FunctionsI 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 &q…
-
Vlookup Contact List... Recognition after SaveIn Formulas and FunctionsI'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 r…Answered - Pending Review 32 views 2 comments 0 points Most recent by Thomas Whiteley Formulas and Functions
-
How to return more than one value with multiple serach values with vlookupIn Formulas and FunctionsHi, 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…Answered - Pending Review 51 views 7 comments 0 points Most recent by Andre Ramos Formulas and Functions
-
Cell links break when adding new row. Work again when saving linked (unchanged) sheet.In Formulas and FunctionsHi 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 re…Answered - Pending Review 23 views 1 comment 0 points Most recent by Krissia B Formulas and Functions
-
Looking for most recent dateIn Formulas and FunctionsI have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
-
Counting checkbox's for children without counting the parentIn Formulas and FunctionsOK 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 r…Answered - Pending Review 11 views 2 comments 0 points Most recent by Natasha Henman Formulas and Functions
-
Linking Two Sheets to update dynamically When columns are added and removed.In Formulas and FunctionsI have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
-
Cell Linking to Sheet Summary FieldIn Using SmartsheetI like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
-
Autopopulated customized response after form submissionIn Using SmartsheetI 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 …
