Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

What formula to use

Topic Labels: Formulas
311 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Angelika
4 - Data Explorer
4 - Data Explorer

I need to get the month to date total number of appointments per client, I am still not getting the result that I need I kept getting the total number since they started. Help please

2 Replies 2
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
more details needed, preferably with screenshot of some example - what you get and and what you expect with the current formula text

Does this look right?

Screenshot 2024-11-07 at 9.39.28 AM.png

If so, you can try using a Count field with a conditional like so:

Screenshot 2024-11-07 at 9.39.33 AM.png

Link to base