I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet. =COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 …
Hi - I am having a problem with my SUMIF formula when it contains the 'Scheduled' column. My formula works if I remove the "Scheduled' column, but when I add that column, I get the message '#Invalid D…
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also…
=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1)) Hello i am trying to find non blank in a column based on the criteria that is after 1/1/…
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm tryi…
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pac…
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather…
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date col…
Hello! I am looking for some assistance on a formula. I have a Master Sheet and a Helper Sheet. I am trying to calculate the number of specific events associated with a person within a date range util…
Hi - I'm trying to use an Index/Collect formula to bring back information based upon two text variables that could be included in my search range. Below is the formula as I have written it and I get a…
