-
Searching more than one worksheet to return value
I am utilizing multiple worksheets (one for each year) but have one sheet that has some consolidated information, and I would like for it to be able to pull from the appropriate year sheet. =IFERROR(INDEX(COLLECT({Quote Log 2024 Quote Status}, {Quote Log 2024 Quote #}, @cell = [Quote Number]@row), 1), "") I would like for…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
formulas
Im trying to calculate the remaining amount to be billed on a project based on the Job % of completion, factoring in the original contract amount, the deposit and remaining amount that is due
-
I need a formula to find the average of the Count of Training IDs
I have a grid that intakes via a form, training evaluation answers. Each row of responses has a TrianingID associated to a specific training. I have been ask to find the medium average if the number of responses received per trainingID It needs to be a column formula due the new TrianingIDs populating as more and more…
-
Generate child rows from form and link to a specific Parent
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just discovered, I don't like the way it works. Below is the template I pulled. The last 2 records are what I entered via the…
-
Calculating Averages with Different Columns
Hi - I am trying to calculate average based on different columns, example… Sandra A - TTL Seconds + Kelly B - TTL Seconds + Meri - TTL Seconds + Coen - TTL Seconds = Average of those numbers for each row Does anyone know the formula to do that?
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…
-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
