Combining dates on a report

Desertbird ✭✭
edited 08/11/22 in Formulas and Functions


I have a report that pulls from timecards that have multiple entries per day. Right now I have it for total hours (filtered for a specific comment), but I also need to see how many days this happened, and some have 1- 3 entries per day. How can I get those dates combined into a single instance?

The raw data looks similar to the grid below:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!