-
Multiple IF statements formula help
I am tracking completion of trainings by participants in our organizations using the Symbols fields and I would like to have one column that tells me if each participant has completed at least 1 training. I am trying to do this by using a formula with multiple IF statements but I keep getting an Incorrect Argument Set…
-
RANKEQ showing multiple 1 Ranks but still showing a rank of 2
I'm running into an issue using RANKEQ to determine the top 10 categories with some criteria while working with census data. The formula I'm using is: =IFERROR(RANKEQ([Speak English less than "Very Well"]@row, COLLECT([Speak English less than "Very Well"]:[Speak English less than "Very Well"], County:County, =County@row,…
-
Sheet Summary box COUNTIFS + AND/OR
I am trying to do something similar on the summary of a sheet.... I want to count if proposed start date column is less than or equal to today, as well as if the PC 2 column = one of "S1", "S2", "S3","S4","S5","S6","S7","S8","S9". I attempted by just trying "S1","S2","S3".... =COUNTIFS([Proposed Start Date]:[Proposed Start…
-
Countifs And/Ors
I am trying to count a specific series: Region1 + StatusComplete + Month series =COUNTIFS({Central HUB – 2019 Range 1}, [Primary Column]@row, {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-01")), {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-02"))) Formula only works with 1 Month, once I add the second month, it…
-
Counting Past Due Task excluding marked complete
Hi! Is there a way to count all tasks that are past due based off of date, but exclude tasks that are marked complete? =COUNTIF(Finish:Finish, <TODAY()) Can I add an exemption in this so marked complete is not counted? Please let me know! Branden
-
Send Form for Completion to Individuals with Pre-Populated Fields taken from Data in the Sheet
I have a sheet called 'Farmer Access Survey' which will contain the current data we hold on record for 130 farmers. I have created a form, which I want to send to each farmer to confirm the current data we hold, and collect additional information from them. Can I send a link to the Form to each individual in an Outlook…
-
Can you skip a row and still use Column formulas?
Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a…
-
Collecting valued with IF Dependencies
I'm stumped in trying to average the values in a column ( CMO Dispo) that meets the criteria of CMO column - "Agilent" DOM column - 2022 year Current non-working formula: =AVG(COLLECT([CMO Dispo (Business Days)]:[CMO Dispo (Business Days)], MFG:MFG, ="Agilent", DOM:DOM, =YEAR(2022, 1, 1))) I'm pretty sure its not working…
-
How can I count blank or filled in cells?
Ultimate goal: To have status column update to Complete once all cells are filled in Problem: I'm trying to count 15 cells on a row (not a range), find out if they are all filled in, then once all the selected cells are filled in, the column I'm using for this formula will turn into a check box where I can create…
-
Formula for Current and Past Projects
Hello! We're developing a master project index sheet, dashboard, and reports. We want to showcase summary data on the dashboard for the total # of projects in the current year, upcoming year, and past (any date before the current year) based on the project's Start Date and if the Est. Completion Date (i.e., if it's started…
