Need per user formulas for counting cells
I am trying to create 2 formulas to get information for a dashboard.
The first is a formula that looks at RYGB as well as assigned user and counts all cells if they match both criteria. I tried this but can't seem to get it to work:
=IF([Assigned To]@row = "Clark Everson") AND(=COUNTIF(RYG:RYG, "blue")
The second is a bit more complicated and I took a pass but have no idea. The goal of it is to find and count cells that are due between 7 to 14 days out based on the date in the Finish column and off of the assigned user
=COUNTIF(FINISH@row was how far i got
Help Article Resources
Check out the Formula Handbook template!