Planning, Templates

Automate Values Into Groups With This Notion Formula

Screen Shot 2020-02-04 at 9.18.10 AM.png

๐Ÿ‘จโ€๐Ÿ‘งโ€๐Ÿ‘ง Arrange Group Sizes

This Notion template is intended for those looking to group teams, package large groups of products, or create automatic delegation systems from a sum of values. We're using the mod function here. Mod can be written as mod (number, number) or number % number. 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 fit 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").

Screen Shot 2020-02-04 at 9.18.57 AM.png

Group 3 Formula:

prop("Number of Students") % 3

Result Formula:

if(prop("3") == 0, "Groups of 3", if(prop("5") == 0, "Groups of 5", if(prop("8") == 0, "Groups of 8", "")))

COPY TEMPLATE