Formular for calculating total amount for each department by month, this week, last week and a day

Options
Gregory.Jack
Gregory.Jack ✭✭
edited 01/17/23 in Formulas and Functions

Hi Guys,

I'd like to create a metrics that calculates an amount for each department by this year, last month, this month, this week and last week. Btw i will be refrerencing from another sheet "Sheet - Transport Request". Can you guys help with a formular? Technically, I need help with 4 formulars.

I'm sorry if I am not making it clear. Ill try my best to explain more.


Gregory E. Jack

Beginner Smartsheet Automations

Best Answer

Answers

  • Gregory.Jack
    Gregory.Jack ✭✭
    edited 01/21/23
    Options

    Hi @Genevieve P. ,

    I can't thankyou enough the formulars worked perfectly. Appreciate the help.

    Thankyou!😊

    Gregory E. Jack

    Beginner Smartsheet Automations

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!