-
Help with calculated columns / data manipulation to display in dashboards
It's quite a long one, so bear with me! We have a process where Program Managers provide a status update (among other things) on their programs every 2 weeks (On Track, At Risk, Severe Risk etc.) A program could be sitting at "At Risk" for a 12 months, and this is what I want to display on my dashboard. I want to know what…
-
placing multiple report widgets on a dashboard
how can I place multiple report wigdets on a dashboard at the same time? can you really only select one report at a time? that also means i have to click through the whole folder hierarchy each time? i hope there is a faster way? thanks for all tips
-
COUNTIFS and DISTINCT formula error
Hello! I am trying to count the number of unique customers from one column, that have been flagged with the year 2022 which is recorded in a separate column. Formula I have is - =COUNTIFS(DISTINCT({Customer Name}, {Financial Year}, "2022")) I am receiving the error, Incorrect Argument Set. Can someone help please?!
-
Report Not Displaying All Information in Dashboard
Hi all - I have a report which isn't showing information in one column (YTD Actual) but shows in the others (YTD Budget and YTD Budget - Actuals). When accessing the sheet, numbers are filled in the column so I'm not sure why they numbers aren't showing up on the dashboard. Column preferences are the same. Also, there is…
-
Merged: "mailto:" URL functionality on Dashboards
This discussion has been merged.
-
Assistance Needed with Updating Month-Wise Data and Dashboard in Project Management
Hello everyone! I've recently taken over a project that was previously managed by someone else. I've observed an issue in the project's dashboard where the month-wise data, used for generating graphs, is only available until May (please refer to the attached image). Upon inquiry, I learned that the sheet containing the…
-
Calendar view in Dashboard
We have a sheet that acts as our project calendar and use start/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same view of this sheet (or the report from sheet) in a dashboard. The report widget only appears to generate a gant view.
-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
