Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The…
I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box. I want to create the same sheet that shows a count of each sheet per cell. So, how many of…
I am having some trouble with creating COUNTIFS functions that reference cells across multiple sheets. I'm trying to create an active dashboard that will reflect performance data over the following pe…
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship …
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any he…
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns…
Hello, My team is tracking hours spent on assigned tasks. We have our SpartSheet set up with: Parent Row : Date, and Total Hours spent for Child Rows Child Row: Team Member, and Hours spent I am looki…
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of m…
