Hey All! My team is looking to add sheet summaries to already existing sheets. Is there a better way to add the fields than going into each sheet one by one to add them? Appreciate any answers! 😀
Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HA…
Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet…
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formu…
Is there a way that once I have grouped in the primary data in a report I could sort by due date in that report? I have grouped the primary column and then summarized the start and due dates, but woul…
Hi! Trying to create my sheet summary. I have one column, Orders Keyed, and a second column, # of errors. I have created a summary for each total. Now I need to get a percentage out of those. i.e. 18 …
I am working on a donor management tool and am looking to count the number of donors previously identified as "lapsed donors" who are no longer in lapsed status. I have created this formula within a c…
Hello, I am curious whether there is a means by which I can use a Sheet Summary field to group and/or sort rows in a Row Report. For example, I want to give a group of sheets a "Priority" field (1, 2,…
I'm looking for a way to make the first row of a project schedule show the earliest start date and last end date without having to make all rows under #1 subordinate to row #1. This is just a pet peev…
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the be…