Jul 04 2022 11:39 AM - edited Jul 04 2022 02:09 PM
ddfdsfdfdsfsdfsdf
Jul 04 2022 11:53 AM - edited Jul 04 2022 11:54 AM
Without trying to understand your formula, you might try (untested):
=SUMPRODUCT(ISNUMBER(FIND({"yes, Approved, Accepted, Correct, Done"},
LOWER(Table[comment])))*(YEAR(Table[date])=YEAR(TODAY()))
*(WEEKNUM(Table[date]+0)=WEEKNUM(TODAY())))
And if that does not work, change the comma to a semicolon in the array-constant, to wit: {"yes; Approved; Accepted; Correct; Done"}
And more flexibly, enter the strings into a contiguous column or row range, replace the array-constant with the range reference.
Jul 04 2022 12:53 PM
Jul 04 2022 01:48 PM
@JohnTaylor20 wrote: ``it didnt work, the result is 0``
Sorry to hear that. Hopefully someone else will have more constructive ideas. Good luck!
Jul 04 2022 03:14 PM
Jul 04 2022 03:56 PM
Perhaps you mean
=SUMPRODUCT(--(MMULT(
ISNUMBER(FIND({"yes", "approved"},LOWER(Table[comment]))),
{1;1} ) > 0 ) *
(YEAR(Table[date])=YEAR(TODAY()))*
(WEEKNUM(Table[date]+0)=WEEKNUM(TODAY())))