-
Absolute Reference Changing
Hi Guys, I'm having an issue with an absolute reference changing, I submitted a support ticket, but I wanted to ask here as well So I have a sheet that is submitted to via form adding rows to the top. The operator puts values in the form, and formulas return RGB if the values are good. I want to pull all the "Red" values…
-
Finding Distinct Values from two different Sheets
Hello, I have a scenario where I'd been successful in summarizing the distinct users names who'd created entries in my sheet and done some calculations from that. Below is my formula: =IFERROR(INDEX(DISTINCT({NCP Originator}), Index@row), "") Now, my records have gotten to a point where I needed to archive older records,…
-
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…
