-
Multi-level approval notification challenge
Hi There, I am try to create a multi-level approval form, where I have created several columns to hold dynamic approver names (based on the submitter), based on a specific set of criteria. I then use a VLOOKUP formula to populate the text field from a contact field in a 'reference' SS containing the relationships ofβ¦
-
Contact Column Enhancement Request
1. Please allow me to at least use an if statement for contact columns. 2. It would be nice to be able to reference 2 emails, either / person or even /cell. 3. Please allow for a phone number to be associated to a person in the cell. I want to send texts, and I know I can send a text via email, but if their email isβ¦
-
Referencing a Contact with VLOOKUP
I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list. I have another sheet, a time sheet, which needs to reference that supervisor column with vlookup so that approvals can be sent to that person for hours logged. Itβ¦
-
Multiple contact list in a column
Hello, Is there a way to create multiple sets of group contactsΒ or drop down lists in a single column so that onlyΒ a specifiedΒ set ofΒ contacts or individuals can be selected based on what information is selected in a drop down list from an adjacent column? For example, if I have 100 people in a contact list but, they areβ¦
-
Populating Contact Column - Multiple rows with single cell entry
Hello Folks, I have aΒ new employee onboarding Smartsheet template I created with 100's of rows / tasks for various departments to complete and I need to set reminders up for different dates (10 days prior to starting work, the day prior to starting work, day one of work, first week of work, onboarding follow-up and 90 daysβ¦
-
VLookups in a Contact field
I would love to be able to have one table with contacts (i.e. administrative support personnel)Β and use a Vlookup function to insert the correct contact into a row on another table. We have a lot of turnover in those positions, so it would be nice toΒ be able to update the separate Administrative table and thenΒ let itβ¦
-
Contact column does not support formula?
Hello there, I have encountered an issue for Vlook up for contact list. It gives me a message thatΒ Contact column does not support formula. Can you please assist us. Please see attached image. Thanking you.
-
Auto Fill a Contact Column
I need to have a contract cellΒ automatically fill with the contact cell above it. The column type is contact list and I want the user to be able to select the contact in the first row and have the rest of the rows automatically fill with that contact.
-
Image Widget Linked to a specif set of rows in a sheet
Does anyone know if there is a way to link an image widget directly to a selected amount of rows in a sheet? I currently only see the option to link to a full sheet, but want to direct the user to a certain section of the sheet.
-
Dependency Setting
Greetings, I have a Smartsheet (Smartsheet A) with multiple date columns. These dates have been added using various formulae. I also link some of these dates into a master sheet (Mastersheet A)Β that consists of a Gantt Chart. The dependency settings on the Mastersheet AΒ with the Gantt chart is such that there are only 5β¦
