-
% of check boxes
I am trying to make the row 20 box thats selected to display a % of the check boxes in rows 2-19 that are selected. I have tried a couple formulas none work. =COUNTIF([Complete]2:[Complete]19, 1) / COUNT([Complete]2:[Complete]19) =COUNTIF([Complete]2:[Complete]19, "true") / COUNT([Complete]2:[Complete]19)
-
How Can I Set Up Hourly Archiving Without Breaking Datamesh?
Hi there, I need help setting up an hourly automation for our Department Calendar sheet. Here’s the situation: This sheet is connected to the Master Events sheet via Datamesh. When an entry is cancelled, Datamesh needs to trigger on the master sheet before the entry is archived from this sheet. If the entry is archived…
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…
-
Using a form to collect data on a sheet specific to a row
Context: We have sheet with a list of dates and meeting types as parent rows and then the agenda for each meeting as children rows underneath. In each row with an agenda topic, there is a cell that shows the presenter. We would like to collect details on who is presenting from non-editor users. I created a form that allows…
-
COUNTIFS from two columns on a reference sheet
I have a reference sheet where I'm trying to count the instances of "Needs Review" from the "Status" column and then add a COUNTIF the "Most Recent Action Date" column as a date in that column. I can write the two formulas individually, but I don't know how to put them together in one cell. I get unparseable when I try to…
-
Adding If statement in a formula
Hi, I am using the formula below and now someone entered a word instead of numerical. Is there any way for me to have to not produce "invalid Operations" just because it's not a numeric info in one of the columns? [AMF Expensed per Audit]@row - [2025 AMFs billed]@row
-
Counting items created within a certain date range
I am trying to create a formula that counts the number of rows that meet a certain criteria. In this instance, i have a date field called "Created". I want to know how many rows were created in the year 2025.. Any thoughts on how i could accomplish this? I appreciate it.
-
Return multiple values based on two cells.
Using a VLookup I was able to get the budget manager column to return the multiple values based on the paying department. However, I also need it to return another person if the grant option is selected. The budget manager column on the first sheet is used for a filter on a dynamic view to allow only the contact and budget…
-
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
-
Can you parse a summary field from a report into another report?
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.