SUM FROM A COLUMN WITH DATE DYNAMICALLY CHANGING

AppSheet AppSheet Q&A
1

I HAVE A TABLE WHICH HAS A COLUMN NAMED CONTACTS AND HAS NUMBERS. ANOTHER IS CALLED WEDNESDAYS AND HAS DATES. HOW CAN I GET THE SUM OF CONTACTS FOR A SPECIFIC DATE WHEN THE DATE IS DYNAMICALLY CHANGING?

2

please share the table screen shots for better assistance.

I think you are asking to count the number of contacts for the particular date ? may be today ?

probably this could help you

count(
select([tablename[column name - may be the key column], [Date column] = TODAY())
)