Count Number of occurrences

[Majeed]

Dear Appsheet Community,

I hope this message finds you well.

I have an app with two tabes.

A table named VISITS which records all the visits to clients made by each one of my sales reps.

VISITS has a [VISIT DATE]  column. Each row of VISITS corresponds to a visit to a customer by a sales rep.

In a separate table named R/O, in a column named [WORKED DAYS] I am looking to calculate the number of days each sales rep has recorded at least 3 visits in a given week.

I have tried this formula:

COUNT(SELECT(VISITS [VISIT DATE],

AND(

[SALESREP]=[_THISROW].[SALESREP],

ISOWEEKNUM([VISIT DATE])=[_THISROW].[WEEK NUMBER],

,TRUE))

This formula is incomplete since it doesn’t take into account the “at least 3 visits” filter criteria.

I don’t manage to find a solution to count only the dates where at least 3 visits have been recorded by a sales rep.

Any ideas about how I could achieve that ?

Thank you in advance

[Luis_Rodriguez_]

hi @Majeed try this:

IF([your formula]>2,[your formula],"")