-
Can I add the totals of two or more Summary Fields to create a Grand Total Summary Field?
-
Summary formula
Hey I'm trying to do this in a Sheet Summary: If [Date] is today, then show me the value in the same row in column G. This works for an individual row (1) =IF([Date]1 = TODAY(), [G]1, 0) But I can't get it to work with @row to search all the way down the sheet to look for the current date, I've tried these: =IF([Date]@row…
-
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.
-
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.