Project Management
Discussion List
- Hi, Our ERP system exports tasks and the materials needed for those tasks with the same task ID number. We schedule based on the actual task and predicted duration. Is there a way to automatically ass…
- We have a form which is sent to customers to register their commercial contact details. The customer doesn't always know which product they are receiving so this is added to a sheet column after popul…
CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below. I have 4 current p…
- I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria a…
- Hi, Can anyone suggest how to import the data in bulk from excel, the number of data is around 37000. I can see that we have limit upto 5000, On Smartsheet I have to weekly import the data for the pro…
Is there a formula that will help me to determine if a task has any dependencies (IE: the opposite o
I work on some pretty complex projects and the templates we use have hundreds of tasks that are linked together using the predecessor column. Each project is slightly different and we usually need to …- Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summatio…
- In order for us to justify getting our whole team into Smartsheet, we need to be able to measure utilization. Is there a way to roll up utilization to the group level, in the same way that we can roll…
- We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet. Here are some details: * We have 8 employees that can weld. * Some of the 8 can work on small parts, some can work on …
- Good afternoon all I am fairly new to smartsheet but an intermediate user of Excel. For some reason, my multiple stacked IF OR formula for Dates is not working - i know it must be simple but ive been …
