-
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 delete certain tasks to refine the template into a new project plan. It can be a pretty big pain to delete some of the tasks…
-
What sheet types can I use the 'new' DURATION column in?
I NEED to build a timesheet - of some kind - what sheet types, templates can I manipulate that have teh Duration field inbuilt (Gantt sheet is fine, we will just use the grid view). As from what I can see a 'blank template' does not come with Duration as an option. Is this correct? Cheers team!
-
Automating Parent Row based off BRYG Children Rows
I am looking for a formula that will mark a parent row "Green" when and only when all children rows have been marked "Green" for completion. Each children row has a formula that bases of when each task was completed by date and will mark that row "Green" for completion dates that are today or in the past. Thanks, Josh
-
Resource Management: Can we roll up utilization to the group level?
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 up utilization to the user level? Essentially, the goal is to know how much our utilization for a group is for a specific…
-
Cross-Link Dependencies
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt…
-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
Prevent deletion of rows if it contains locked cells?
We are trying Smartsheets for a project and are running into a major issue. The sheet contains checkboxes of things to do, along with dates, and who did the particular task. It is crucial that the 'Task' and 'Date' columns be protected. Unfortunately, we're finidng that if you are an editor, even though these two columns…
-
Sending alerts in advance of start date
Hi all! I need to schedule a row-by-row reminder 8 weeks in advance of the row start date. I've looked at the 'alerts' feature at the bottom of the sheet but it looks like the maximum I can send a reminder in advance of the start date is 14 days. Is there a work-around here? The sheet I've created is a marketing calendar…
-
Template that automatically sends notifications to assignees on due dates
I'm trying to find an app that automates our processes — finance to training to sales. I want to create a template that I can that I use every time there is a new job to do. When training is booked for example, I want to create a new sheet, add the date of the training and have all the due dates automatically calculate. I…
-
Copying Cell Linking
Is there a way to copy and paste a row and retain its cell links to the pasted row?
