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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!