-
Copying Automation Not Working
I am trying to set up an automation to copy the row to "90-day Reviews" whenever a new row is added. Can someone please help me figure out why the rows are not copying? The sheet that I am trying to copy to has the exact same rows as the master sheet with the exception that the master sheet has the first two rows hidden as…
-
What is the best way to combine these 2 formulas and simplify it.
=IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPD", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 72, (PINK@row + RED@row / 4) / 72)))) =IF(SPECIES@row = "Roses", IF([TYPE OF POT]@row = "LPS", IF(PINK@row = "", IF(RED@row = "", [Type]@row / 36, (PINK@row + RED@row / 4) / 36))))
-
Index Collect
Hi all, I wanted to see if anyone could give an ELI5 version of how index collect works and some use cases. The only youtube video I found was just an example without explanation on the syntax and why/how it works. I already know how index match works, but the index collect is throwing me off. Thank you so much for your…
-
Want to do an IF/AND but not skilled enough to make it work
=COUNTIFS([Proposed Finished Year]1:[Proposed Finished Year]22, 2022, [Strategic Initiative]1:[Strategic Initiative]22, "Revenue Growth") COUNTIFS({Sheet - Project Requests Range 2}, Primary35) Trying to tie the two formulas together to count each initiative (there are 5) in rows and only for 2022.
-
Sheet summary formula
I have several status for work in progress. They are very detailed and granular (not started, writing in progress, review 1, revisions 1, review 2, revisions 2, editorial, final review, ready for client). I would like to create a sheet summary that counts several of these statuses together (example: grouping writing in…
-
How do I get a formula to understand that 10 is 10 and not 1? It is not factoring in the zero.
I have this formula in a calc sheet for reference: =COUNTIFS({Month}, HAS(@cell, "10"), {Contact Method}, "Booking Appointment") The “10” is meant to look for dates that start with 10 for the month and this formula has worked for 1-9 months, but now for October it is pulling January because it’s only looking for “1”. How…
-
=[Sheet Column]@row = "" not working (from Date type)
So I have a Last Updated column that is a Date type, then I created a temp column just to test this where I apply the formula [Last Updated]@row + "" to a cell in temp and i just get the same value I have in Last Updated. I've tried changing the column type for temp to both Date and Text/Number
-
Formula to calculate the last day of the year based on another date column
I have a sheet that tracks Agreement Execution Dates, and I would like my Agreement Expiration Date column to record the last day of the year of execution (so if executed 5/1/20, expiration would be 12/31/20). How would I write this?
-
How to count when you have multiple crteria in 2 different columns you are trying to capture?
=COUNTIFS("[Interested Volunteer Role]12:[Interested Volunteer Role]85, "Vaccinator (Clinical)", [Interested Volunteer Role]14:[Interested Volunteer Role]82, "Dunkin Donuts Park-Hartford, CT 11/14/21 (Dose 1); 10am-4pm") So for example if they chose they want to be a Vaccinator (Clinical) but can only help on one date…
-
Can you do a Countif on a column that has a "Dropdown multi-select"
=COUNTIF([Date/Venue of Interest]8:[Date/Venue of Interest]93, "Dunkin Donuts Park-Hartford, CT 11/14/21 (Dose 1);10am-4pm") The colum has the following options to choose from for multi-select & I want to be able to count how many people are selecting for each date & time slot if that makes sense. Dunkin Donuts…