-
Count unique projects
I want to count the number of unique projects under a particular workstream. For example, a workstream might have three projects under it, but each of those projects might have three people assigned to it. That's 9 occurrences in that workstream, but only three unique projects. How can I count the unique projects under…
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
Is it possible to select multiple sheets and share at the same time?
We have roughly 35 sheets that need to be shared with a group of people. Is there a way to do this in one transaction rather than sharing each sheet separately? Thanks!
-
Calendar app not showing line items when more than one value chosen in a multi-select filter
I can see line items properly in regular SS calendar view but in the calendar app it is not displaying items it should when I filter for line items that have more than one value selected in a multi-select column. When no filter is selected, the line items appear. The filter works when i chose ONE value but not when i chose…
-
Removing duplicates by moving to another sheet
Hi, I have sheets A and B. Sheet A is set up that with a row that marks all duplicates as 2. I want to set up a formula that says, "If a column Duplicates is marked 2 and the customer information contains the word outdated, only move the first occurrence to Sheet B. " Leaving one copy of the duplicated on the sheet. Thank…
-
Formula to copy parent data to child
Working with Tasks and SubTasks I dont always have SubTasks but when I do, I'd like to bring data from the parent to the child row. Can this be done with a formula?
-
Combining Columns on Sheet from Form
Good afternoon, I am working on an audit stock sheet, that allows a form staff can utilize for active counts and confirm physical location. With this I am trying to find the function to combine rows with the same Product Name, Product ID, but have the differentiator being the room it is stored in. See screen shot: With the…
-
Mapping out References
Is there a way to aggregate all of the managed references (both cell and sheet) without having to collect it manually? For example, I have one sheet that contains 14 cell references and 39 sheet references. Is there a way to export a map of those references so the client can see them rather than them hovering or going into…
-
Filter only children row when certain criteria is met.
Hello Community, What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked. Once I am able to filter the rows that…
-
Changing more than one sheet
Hi, I was wondering if there was a way to alter sheets based on a single template without having to go into each one individually? If I had a template that I used for different task lists and I wanted to add a column, automation, or even a choice in a dropdown, is there a way for me to do that simultaneously throughout all…
