Red Gregory

View Original

Automate Values Into Groups With This Notion Formula

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").

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