-
Why can't I change the project name on the dashboard?
I am a new customer with the Pro plan but I am unable to change the Project Name on the Dashboard. It reads "Project Name in Summary Sheet", so I go to the Summary Sheet and it is grayed out with no option to edit. Please don't tell me I need to pay more to change the Project Name.
-
Chart Dashboard Widget using Sheet Summary data fields
It would be great to be able to use the chart widget with data held at Sheet Summary level. Appreciate that there are 2 ways around this : Create a report and chart against that Add "helper columns" to the sheet itself However, I'd prefer to reduce the number of new reports I'm creating, and keep sheet complexity lower…
-
Sheet summary dropdown field not accessible on mobile
The sheet summary is accessible on the mobile app but the fields can not be edited, is this true?
-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Getting the difference between a past date and today's date
I want to use the sheet summary to report how long a project has been put on hold. So I have the date that the project got put on hold, which is Aug 9, 2023. I want to automate the calaculation of how many days it has been at any given time. I've tried multiple formulas and none of them are working. Even typing in =TODAY()…
-
I'm having issues with COUNTIFS - can someone help?
This works =COUNTIF(Priority:Priority, "P1") This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Priority:Priority, "P2") This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Status:Status, "Done") but it adds them up I can't get the countifs to only show records that are P1 AND (Done OR Declined). I've looked…
-
Counting Checked Boxes in one column
Hello, I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas: =COUNTIFS([Missed Information:Missed Information], 1) =COUNTIFS([Missed Information : Missed Information], 1)…
-
Formula to use in the summary field for the number of rows within a specific column
For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.
-
Change Sheet Summary Field Name from Sheet Summary Report
We are working on a client project. We have 15-20 summary fields and we want to create 5-6 more. The problem is if we add exact names of 5-6 fields, it will take hours to finish it. What we want is to name those fields as 1,2,3,4,5,6 and save it quickly. After this activity, we can. create a sheet summary report and change…
-
Merged: Automation/Workflow from sheet summary fields
This discussion has been merged.
