 Need help with formula based on time

Hi everyone! I’m having some trouble with a formula based on time, this might be simple for some of you but I’m desperate for help Here is the doc:

For this week, try this formulas:
`[Clients de l'Agence P2P].filter([Date of onboarding]> (Today() - 7)).Count()`

Or better to make week and month dynamic, try those formulas:

• For this week:
`[Clients de l'Agence P2P].filter([Date of onboarding]>(Today().DateTimeTruncate("week"))).Count()`
• For this month:
`[Clients de l'Agence P2P].filter([Date of onboarding]>=(Today().DateTimeTruncate("month"))).Count()`
1 Like

Thank you so much @Rami_Sedhom! This saved my a lot of time I am also struggling with another sheet, so I’ll just drop this here if you have a minute today and would like to play with someone else’s formulas, it would mean the world to me Here is the sheet, I have put instructions at the bottom of what I am having trouble with so you don’t waste your time.

Thank you again

If I understand correctly, following are the formulas:

`[All leads - Call Times].Filter([Campaign type]="Listing ad" AND Stage="🏆Appointment").Count()`

`[All leads - Call Times].Filter([Campaign type]="Listing ad").[👉 Score (1er appel)].Average()`

Calls to appointments: 4
`[All leads - Call Times].Filter([Campaign type]="Listing ad").[👉 # of calls].Sum()`

`[All leads - Call Times].Filter([Campaign type]="Listing ad" AND (Stage="🏆Appointment" OR Stage="🗣 Voicemail Sent")).Count()/[All leads - Call Times].Filter([Campaign type]="Listing ad").Count()*100` %

@Rami_Sedhom thanks again for your help

2 of the 4 formulas worked, I made it easier to understand if you still have time for this I really appreciate what you are doing, it helps me a LOT. Thank you

*Is it possible to round a formula? The % of leads contacted is very long…

@Paul_Danyliuk @Nick_Milner To round the number, you can wrap your formula in:

• `Round()` — second parameter is number of digits after comma. Alternatively `RoundUp()` or `RoundDown()`.
• An experimental `FormatPercent()` formula — and ditch the `* 100` and the explicit percent sign.
2 Likes