-
Automatic Convert Email Address to Hyperlink
Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink? Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However, its text, not an email address contact/hyperlink. Ultimately, I need to have a way Smartsheet can use the email address to…
-
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.
