-
Help on Countif formula
Hi I am trying to create a countif formula with multiple criteria . Heres what I am trying to do Countif Column1 = 1 and column 2 = N/A or Received at home I tried this formula but assume it is a check And for all 3 conditions as I get a value of 0 =COUNTIFS([Campus Id #]:[Campus Id #], =1, [ASA Not Given in ERSquad]:[ASA…
-
Parent/Child References
I am trying to use COUNTIF to refer to the number of projects that are under a certain parent row. I am having a hard time not coming up with a #INCORRECT ARGUMENT SET error.
-
Stuck on If Statements
Hi team, I'm building a dashboard and I need to show the current metric. I thought I'd show this by showing each month (for a chart) and using this formula to obtain the current: =IF(DEC3 = "", NOV3, IF(NOV3 = "", OCT3, IF(OCT3 = "", SEP3, IF(SEP3 = "", AUG3, IF(AUG3 = "", JUL3, IF(JUL3 = "", JUN3, IF(JUN3 = "", MAY3,…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
-
How do I return a value, based on a date, between dates? (versus week numbers)?
I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is IF the date condition falls between a start date and finish date. I have been able to do this when I convert all dates to a…
-
Formula for selecting correct Image
Hey folks looking for IF statement that would allow me to specify a number ranges from one cell that contains a number to then display the appropriate Arrow. Any help in changing the formula would be great. Below is not correct but hopefully gives you the idea =IF([Heat#]1 <= 4, "Down", IF([Heat#]1 <= 8, “Angle Down”,…
-
Copying comment text into another cell but only when a certain value is triggered
Hoping you can help! I'm trying to setup a formula where if I have a Red RYG ball in a cell of a task row then the comment next to it copies into a different cell (on the same sheet) for reporting. I know I could just create a report which looks at values in those columns and trigger only when there's a red ball along with…
-
Is there a limit to the length of If/And Statements?
I have the following statement and it works for the bold section but when I add the italic section I receive an 'UNPARSABLE' error. Thoughts? =IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "<25"), [Column2]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "26-50"), [Column3]2, IF(AND([From Calculator]2…
-
Counting for this year only (Formula help)
Hi All, I have a sheet that has been populated via forms for the past 12 months. What i would like to do is use a count if formula but only when the date is this year. my current formula is =COUNTIFS({Pure Gym Issue Type YTD}, "HR / Lateness or leaving early") This works really well but counts everything on the sheet, can…
-
Counting all siblings below a master Parent
Hi, One of my sheets has a master Parent and have several parents and childs below. What could be the formula to count all items below any Parent, which counts all parents and childs below? Thanks in advance.