Countif - to count how many matching dates are in one sheet onto another sheet
New to smartsheet but thought i'd clocked how to do this.
- I have a set of dates in one column on one sheet
- On a seperate sheet (master) I have a column that counts the number of times that date is matched to a date in this sheet
I have tried the following:
these either bring up #parseable or 0 which isnt the figure I am looking for and doesnt match the data. any tips?
Help Article Resources
Check out the Formula Handbook template!