count cells with the same date that are NOTBLANK

Mixer ✭✭✭
edited 12/09/19 in Formulas and Functions


I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date.

Sheet1 has several ROWS with the same dates. Sheet2 has only one date per ROW. I would like to COUNT Sheet1 rows that have equal Dates and insert it in every row in Sheet2. but the other criterion I neet is that Sheet1 column is NOT BLANK (but other than date column)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!