Trending in Formulas and Functions
CountIF won't recognise the result of a formula
I have a column that contains a column formula driven from a date. GRID COLUMNS Detection Date = DD/MM/YY Year = formula: =20 + RIGHT([Detection Date]@row, 2). Result = 2023 Sheet summary This Year = formula: =20 + RIGHT(TODAY(), 2). Result today = 2023 Breach This Year = formula: =COUNTIF(Year:Year, [This Year]#). Result…
Month, Year Calculation Formula
For example if I get Month, Year Value as (1, 2023) i,e Jan 2023 using =MONTH(TODAY()) - 11 + ", " + YEAR(TODAY()) formula what is the formula we have to use to get Previous Month, Year Value (12, 2022) i,e Dec 2022.
Imbedded If Statements
I'm trying to use a formula (below) that will: 1)If a deviation was Approved, it is past its End Date...if Past End Date return "Expired", if not return "Active" 2)If it was never Approved, return "Rejected"......no need to evaluate if it is past its End Date. My formula is returning Rejected only. =IF([Approval…