- COUNTIF Formula Providing Incorrect Result
Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect. The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct) I tried this formula on a second sheet and still received an incorrect…
- COUNTIFS and Duplicate Values
Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once. Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column…
- Data Shuttle Not Adding Net New Entries
Hello! I have set up Data Shuttle with the intention that the PM on the project can attach the daily issue log she receives from our IT department and her sheet would be automatically updated. She document she receives from IT is an .xlsx spreadsheet. I noticed that with each new attachment, the existing data would be…
- Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
- IF Formula with Multiple Criteria
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the following: 1 - Unknown, 2 - High, 3 - Medium, 4 - Low, 5 - None The change score change range from 4-25 The breakdown for priority…
- Formula to bring back value of a cell based on month
Hello! I need help figuring out a formula and possibly on how to set up a helper sheet to get the formula to work: I currently have a capacity plan for our team. My leaders would like a widget on the dashboard that will just show the team members' names and their allocation for the current month. So I need help figured out…
- Copy Row Automation
Hello! I have been tasked by my team's leadership to create a way that they can audit how often my colleagues are updating their project plans. We currently have a "Master Sheet" that lists all of our current projects and certain cells linked in from each project plan. The project manager is supposed to be updating their…
- Linked Cells Don't Match
Hello! I am attempting to link cells (Duration, Start, Finish) from a project's sheet to a master sheet. However, once I link the cells, the Finish date is different on the master sheet than what has been entered in the project's sheet. Cells in project sheet: Cells in master sheet: The Finish date should be 1/2/23, not…
- Linked Cell Not Working
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
- 里程碑时间不计算相关系数ectly
When putting milestones into a project plan, the duration is calculating as "1d" instead of "0" like it should. I cannot figure out why this is happening. Can anyone please advise?