-
If(And) #unpareseable error- help
Hi I am trying to write a formula to check values in two columns to set a flag on or off. If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error. Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1). Any guidance…
-
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…
