↙️

Arrange Values into Groups

Master Tag
Tips & Tricks
Created
Feb 2, 2020 06:07 PM
Usage
Mod
Web Tags
Planning
Formula
Database
Alternatives
Cover
↙️
This template is intended for those looking to group teams, package large groups of products, or create automatic delegation systems. We're using the mod function here →
↙️
In this example, we want to know if we should group the following students into classes of 3, 5 or 8. mod or % returns the number of students left over if we were to group them into the corresponding group size. The goal is to see the number 0, indicating that every student can fit into the group size. Also, let's assume that one group of students fits into two sub-group possibilities (as is the case with Group B - Intermediate). For the example below, we want to choose the smallest possible group (5). To accomplish this, place the if string that contains prop("5") before prop("8")
Group Teams Example