-
Automate Notification
I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting the same information twice in the sheet. What I am wondering is if there is a way to…
-
VLOOKUP to another SmartSheet
When will we have the ability to VLOOKUP a value on another sheet? I link to a cell in another sheet now when the location is static....but in this situation the value is not in a certain cell.
-
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.
