Combining dates on a report

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

Hello,

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:


Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!