Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Send an email when assigned task
Hello, Is there a way to have an email sent to someone when they are assigned a task. For example if there was a task that was assigned to nate, and it now gets re-assigned to dave can the system send dave an email? - Adam
Resource Management in Hours and Task Rollup
I recently started using the Resource Management tool and I have two questions about it. We are using 1 sheet only. 1) Is there a way to display hours vs. percent allocation? Everything I have seen with this feature thus far seems based on the latter and I'd like the option to report on the former 2) Is there a way to…
Editing Conditional Formatting Rules
Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to…
Count days between start and end date
I want to show count of days between start date and end date
WORKSPACES
We recently had an employee leave who created work spaces and when we transferred ownership those workspaces turned into sheets and i can not move them back to the workspace folder. please help! i need them moved for my reporting.
PICK CHART and Smartsheet Template
A PICK Chart is a very effective Lean Six Sigma tool used to categorize process improvement ideas https://www.vertex42.com/ExcelTemplates/PICK-chart.html I am still a newbie using Smartsheet -- is there a template or can SS be created to match the example "Action Item List with PICK Ranking" shown in the above URL (near…
Use query strings to populate a contact list dropdown value in a form
Is it possible to pre-populate a dropdown field in a form with a query string value when the values of the dropdown field are set to contact list and have a pre-defined set of people?
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…
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…
