Database

Count Cells That Meet A Particular Status In Notion

Screen Shot 2020-02-11 at 8.06.01 AM.png

🌴 Count Growth Cells

Using this formula in Notion, find a number of cells that meet a particular requirement. For example, say we’re comparing Lucy's Bakery's cookie sales growth from last month to the current. To determine how many cells increased or decreased growth, use the following functions: larger and smaller.

I have provided the two formulas that will determine the binary growth rate of two values. In addition, if you want to determine how many rows have increased or decreased, look to the bottom of each column where it reads Calculate. From here, click Checked.

Screen Shot 2020-02-11 at 8.13.19 AM.png

Increase Formula

prop("Last Month") < prop("Current Month")

Decrease Formula

prop("Last Month") > prop("Current Month")

COPY TEMPLATE