I maintain a weekly project tracking system across two sheets: Sheet 1 (Project Status): Contains detailed project status updates Adds 20 new rows each week (one per project) Includes a 'Snapshot Date' column to identify the week Sheet 2 (Status Summary): Tracks project status counts (on-track/off-track) by week Previously…
I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with…
Hi all, I am very sorry that I have to call for your assistance but finding the answer is not really straightforward. I have a formula that works, yahoo! but it works if I keep it on the same sheet. Now I want to use this formula that use all the data form another Reference Another Sheet (RAS). Do I have to add the RAS for…
Problem Summary: I have a series of formulas and cross sheet references which grab display data that meet certain conditions. They are working consistently across usage…except for two rows? For data sensitivity, I'll only be including the date fields out of the display data, but the same error applies to all final display…
This discussion has been merged.