-
assign child rows from parent row
I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row. I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the…
-
Setting up notifications and alerts
I am going to have a sheet made for every lot that we land survey on which adds up to a lot. Each sheet I have 13 rows of tasks and 13 rows of columns, 12 of them being contacts and one of them being status of the task. I am trying to set up the notification or alert to contact those in the contact columns when the status…
-
Cell Linking Within Same Sheet
Hello... is there a way to link the value of a text-based cell to other text-based cells within the same sheet? I have a project plan template in which there are several fields in my "Assigned To" Contact List column which will need to be populated with the same person. Instead of even copying/pasting, I was hoping to…
-
Resource Assignment based on a Vlookup?
I am creating templates for repeatable "projects." I would like to have a column of "Role Assigned" and set up a table (filled in when the template is used) that associates a specific person (Contact) with each role. Then in each row, a Vlookup would be used to automatically fill in the "Assigned To" contact name from the…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
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…
-
Contacts list on webform
I would like to use the dropdown list of contacts in a web-form, does anyone know if this is possible? thanks Adam
-
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.
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
