Filter Values when creating a Summary Table?

Ask for Help
7

You can create a Summary table grouped by Team, then modify the default “count” column formula so that it excludes employees with Status=“Gone”:

sum(1 for r in $group if r.Status != "Gone")

See new Summary table widget here:
https://docs.getgrist.com/kGiTiQeo1qbC/Example-Employee-copy?utm_id=share-doc

T