GENERATING WEEKLY REPORT FORMULA

Mariniel Bautista
Mariniel Bautista ✭✭
edited 01/27/20 in Formulas and Functions

I would like to know what formula should I use if I want to produce a weekly report from this database? So the client wants us to give weekly report containing total number of request received for the week, also how many were completed, still pending or on going. (This is just the sample data as reference). Also, what formula if I want to produce a weekly report containing how many request was received from each bank branch, and how many were received per type of work?

Thanks in advance for your answers.

Weekly report.png


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!