Identify unique dates when added to sheet


I have a sheet where my team is recording the date of shoutouts in a column and I am displaying the daily shout out count on a dashboard. Currently when a new date is added to the sheet I am manually adding that date to my summary sheet for the Dashboard and then using a countif formula to count the number of instances of that date. I am wondering if there is a formula/nested formula that would be able to automate adding the new date to the summary sheet.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!