How to create a weekly/monthly report


I need assistance with creating a formula to produce a weekly and monthly report from my Smartsheet? I will need to provide a weekly report containing total number of request received for the week, also how many were completed, still pending or on going. Also, I will need a formula if I want to produce a weekly report containing how many request was received from each responsible area. I tried using =countif but received an error message.

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!