Trending in Formulas and Functions
-
COUNTIFS with multiple criteria from multiple columns
Hi all, I have tried various different formulas from various posts on here but still keep getting Unparseable. I am trying to create a formula, linking from another sheet, to find the following criteria: If the row contains ANY of these values: "未着手 Not Started", "進行中 In Progress", "現場確認 Field Review", "保留中（予算）On Hold…
-
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()))
-
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 <=…
