79324748

Date: 2025-01-02 19:23:08
Score: 0.5
Natty:
Report link

Happy New Year ~ With guidance, I took the recommendations and altered it to combine it with another filter to toggle between a progress of completed or less than 100%.

=FILTER(Table2,(COUNTIFS(Table2[Item '#],Table2[Item '#],Table2[Version '#],">"&Table2[Version '#])=0)*(Table2[Progress Category]=B3))

in the filter function, if you need to add another criteria you can use the * asterisk and add in the next item you need to filter! And to toggle, I used Cell B3 to have a toggle between a list of progress options. Exciting, I know. Thanks everyone!

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Whitelisted phrase (-1.5): you can use
  • Long answer (-0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Jmar