-
Help creating a formula that generates the current fiscal year
The following formula is #UNPARSEABLE. I'm not sure why. Please help. =IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))
-
How to Join values from a reference sheet based on selections in a multi-select dropdown
Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell. In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column…
-
Trying to evaluate multiple columns with an IF statement
I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny" if the status of the risk is "closed" and if not closed, i am using the other icons based on the level of the risk. here is the formula: =IF([Status]@row = “Closed”, “sunny”, IF([Risk Score]@row <=…
-
Find Number of Duplicates within Multiple Columns
I need to create a COUNTIF formula (I assume) that will count the number of duplicates of a number in at least 10 different columns. I will eventually create a notification for the end result but I can't figure out how to do it over more than one column without only being able to compare the other columns to just one…
-
Pasting formulas from a plain text document causing #Unparseable Error
Hello all, I am building a complex multilingual sheet that will be creating various documents using Document Builder depending on the user's choice of country and language. There are a lot of column formulas that are very similar but use different languages. I am using a text editor to track the formulas but have found I…
-
Sheet Reference Formula Unparseable Error
I'm using the following formula, which references another sheet to pull in definitions/text: =IF([Job Family Recommendation]@row = "Accounting Operations", {Job Family Definitions Range 5}), IF([Job Family Recommendation]@row = "Billing", {Job Family Definitions Range 2}) The first leg of the formula works, but when I add…
-
Help with Unparseable If(And) formula
Please help with reviewing the formula below. I am getting #UNPARSEABLE. =IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N") If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, "Y", "N") [Spend 2022] and [Spend 2023] columns are text…
-
CountIF Formula for Dates in the Past
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project. I want to change this to…
-
Formula to calculate working hours
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/hrs (hrs and minutes separated with colons) I Need a formula for column (Working/hrs) that count the number of employee's…
-
SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?
I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must missing a nuance somewhere. Thanks! =SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG",…