Trigger automation based on a count or multiples of a count
Hello. Im testing out triggering an automation based on a countif, but I cant figure out the logic to apply the automation as the countif increases. For instance. I want the automation to run each time we get 5 submittals via a form for the same category. Right now I'm using a metric sheet and a countif with a mod formula.. but that only works if we get exactly 5 submitted before the automation runs.. if we get 6, it fails. Any ideas on a formula that would account for that?