Tracking Financials on a weekly basis appose to monthly

Lifestyle PMO
Lifestyle PMO ✭✭
edited 12/09/19 in Smartsheet Basics

Hi,

We currently track our financials on a monthly basis project by project. We would like to track the resources on a weekly basis to calculate how much they cost weekly. Is there anybody that currently does this and could help us change our financials sheet from monthly to weekly?

Β 

Kind regards

PMO

Comments

  • L_123
    L_123 Community Champion

    Gotta have more info than that. Can you give us your current formulas or data types?

    doing it weekly can be much more difficult. I did it recently and ended up with this formula for my sheet:

    =JOIN(COLLECT($B:$B, $A:$A, $[Work Description]@row, $Created:$Created, NETDAYS(@cell, TODAY()) <= IF(WEEKDAY(TODAY()) = 7, 2, IF(WEEKDAY(TODAY()) = 6, 1, WEEKDAY(TODAY()) + 2))))

    This formula returns the results that are within the last week for which the description matches

    Β 

    Maybe that can give you some ideas, but if you post more info we can help moreΒ