-
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.
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
