Monthly, 6 Monthly, 12 Monthly reporting
I'm currently working on a KPI structure for my organisation. An entry will be made each month via a Smartsheet form, and they'd like to know the latest entry, as well as the last 6 month and last 12 month totals. I'm struggling with how to calculate these. I assume that I'd use the max function along with a created date column for the monthly, although I haven't quite worked that one out either. Any thoughts much appreciated!
Help Article Resources
Check out the Formula Handbook template!