-
Email Notifications
Assume i created a new sheet and added email ids of my resources into a column X in smart sheet where the column X is assigned as contact column. I have created a workflow where any changes to the rows on other columns in the SS, should trigger an email notification to the assigned email id of the updated row from the…
-
Resourcing is looking at SCC template gantts
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…
-
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.