Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to calculate number of member on specific days

Topic Labels: Formulas
485 0
Showing results for 
Search instead for 
Did you mean: 

I have three table :
Table one 【member data】
which have
{start date}
{end date}
{single linked to weekly summary}

table two【activities】
{date of activities}
{multiple linked to weekly summary per person}

table three 【weekly summary per person】
{week number}
{single linked to member data}
{multiple linked to activities}

If I want each activity to have the accurate number of member during {date of activity} , to get the real attendance rate.
How could I do to set up the formula…??

0 Replies 0