Ignore duplicate rows in a report
We record certain metrics about our clients anytime they visit our physical location. This usually isn't a problem because they don't come in too often; however, there are a few times a year when they are scheduled to be onsite multiple times a day. This leads to their name showing up repeatedly on the report we use to list each day's visitors, which in turn causes staff to (annoyingly) ask them the same questions every time they check in.
Is there a formula or filter I can use so anyone visiting our building will only have their name show up once a day (regardless of how many times they are scheduled to come in)?
Help Article Resources
Check out the Formula Handbook template!