-
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.
-
Returning a link if two cells are not blank
I need a formula that returns a specific web link to the cell at the row of my helper column ("Edit/Add Event") if my "start date" and "activity name" are NOT blank. Ideally, I'd also like the link to present as text: "Open Dynamic View". Appreciate any help!
-
Populating data into another sheet when certain criteria is met
I have two sheets that I need to work together - one for project tracking and one for expenses. When I change the "Payment Status" on an activity within my project tracking sheet to "paid", I want specific data from the row of that activity to populate as a new row in my expense sheet. The expense sheet should contain both…