Tracking Financials on a weekly basis appose to monthly

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
-
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Β
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives