Randy Van Winkle
Randy Van Winkle
Discussions
- I have a project plan set up with dependencies. All the parent rows have sub-tasks. When all sub-tasks are completed at 100%, the Parent for the overall project still reads 99%
- I have found other threads for this, and tried this formula =COUNTIFS(DESCENDANTS(), 1) However, I get error #BOOLEAN EXPECTED I have parent rows and grandparent that I would like to calculate
- I got this link from a colleague https://www.smartsheet.com/org-chart-templates-excel it has a bunch of excel templates and then at the bottom it says "Make Better Decisions, Faster by Creating Org Ch…
- I have 21 Project plans with identical formatting. I created a separate sheet to roll up the percent complete in the parent rows by section. I have done similar in the past, however this time when I g…
- I have a list of tasks for the whole year. I would like to create a COUNTIFS formula in a cell that calculates the number of tasks completed in the current month. I've got a formula column that define…
- I've been asked to create a PM tracking system. All the tasks for the year are in one sheet with each task having a row. I a summary section that feeds a dashboard with data showing data points, chart…
- I have a report that is saved in calendar view and a link is placed on a dashboard. When I open the report either directly or via the dashboard link it opens in calendar view. However when shared coll…
- I set up a sheet with a checkbox column called "Confirm complete". I started with 5 children under the main task and got this formula to work in counting the check boxes and displaying a percent compl…
- I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.
- Hello, I am trying to figure out a way to gauge Project Compliance up to Today's date. What percentage of tasks are 100% complete that were due on or before today. In the example the compliance would …
