Trending in Formulas and Functions
-
Calculating Critical Open Items per Business Analyst
I am trying to calculate how many Open items a business analyst has that are in the critical category, this is the formula i am trying to use but i must be doing something wrong Open equals = To Do, In Progress, Daily Task =COUNTIFS({2025 Team Activity Tracker Range 3}, HAS(@cell, "BA NAME"), {2025 Team Activity Tracker…
-
PMO Template
I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula. =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) Could I use a formula to ask it only to count if "Status" is…
-
Need help calculating the percentage of all project tasks and return a value in percentage
Hi, I am trying to add a project status percentage in my project dashboard. I have the list of tasks, % complete, and Task Status in the project sheet. I tried to use the sheet summary to get the % value of the tasks that are not marked "completed" but I am not able to. What is the correct formula to use in the sheet…
