Forum Discussion
asdasdsadsa
ddfdsfdfdsfsdfsdf
- John Taylor, you had a question. Someone tried to help you voluntarily, in their own free time. Deleting the words of your question after that is not very polite. Please have some consideration for this community.
- its cooooo00roooo0na effect
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.
- =SUMPRODUCT(ISNUMBER(FIND({"yes;approved"},LOWER(Table[comment])))*(YEAR(Table[date])=YEAR(TODAY()))*(WEEKNUM(Table[date]+0)=WEEKNUM(TODAY())))
it didnt work, the result is 0JohnTaylor20 wrote: ``it didnt work, the result is 0``
Sorry to hear that. Hopefully someone else will have more constructive ideas. Good luck!
