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.

Best Answer


  • Mariniel Bautista
    edited 01/28/20

    Thanks. I figured it out as well from other community discussion.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Please don't forget to flag the most appropriate response(s) as "helpful" so that others looking for a similar solution know that one can be found here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!