Generating Weekly / Monthly / Quarterly Stats
I have a pretty basic project tracker and I need to create some graphs from it.
The graphs need to be derived for weekly, monthly, quarterly delivered projects. I created a mock up for the monthly stats and would appreciate any help to arrive at these values based on the following logic:
Projects delivered in June = C and D, Value generated = 1027+500=1527 this number needs to be updated alongside June by using a formula that references another sheet.
Thanks in advance. I am sure this is a problem someone has already solved and I am having a hard time figuring out formula + sheet referencing since I am new to Smartsheet.
Help Article Resources
Check out the Formula Handbook template!