There is a major flaw in Notion that I hope gets fixed and that is incorporating column values into formulas. At least from what I gather, it requires a small hack and work around to make this function possible. And yes, it is possible. Below I will try my best to explain how I managed to find a solution.
Step 1
Let's say we're trying to divide all values in the Tags column by all entries in the Name column. What this means is if there are 15 rows of Names that are filled, 15 will be the value we are using by selecting → Count All. There are 15 rows in Tags as well, but we only want to count rows that have data. This will require us to select → Count Values.
Step 2
Next, add a formula property labeled Result, then add three new properties to the table → Relation Hide Rollup Name Hide, Rollup Tags Hide of which should be hidden after this tutorial.
Relation Hide → Choose the database you're working in, and choose Use the sample property. Next, add all entries into one cell.
Step 3
Now, we are going to setup our two Rollup properties. Click Rollup Name Hide cell → Select the following:
- Relation: Relation Hide
- Property: Name
- Calculate: Count All
Click Rollup Tags Hide cell → Select the following:
- Relation: Relation Hide
- Property: Tags
- Calculate: Count Values
Step 4
Let's look at the Result column now and make our formula. The following arrangement can be copy and pasted into result in order to make a simple calculation. Rollup Tags Hide divided by Rollup Name Hide. Of course, you may develop a more complex result with the values you'd like to plug in.
Simple Division Formula:
prop("Rollup Tags Hide") / prop("Rollup Name Hide")
If-Statement Division Formula:
if(prop("Rollup Tags Hide") / prop("Rollup Name Hide") == 1, "★☆☆☆", if(largerEq(prop("Rollup Tags Hide") / prop("Rollup Name Hide"), .9), "★☆☆☆", if(largerEq(prop("Rollup Tags Hide") / prop("Rollup Name Hide"), .6), "★★☆☆", if(largerEq(prop("Rollup Tags Hide") / prop("Rollup Name Hide"), .5), "★★★☆", if(largerEq(prop("Rollup Tags Hide") / prop("Rollup Name Hide"), .4), "★★★☆", if(smaller(prop("Rollup Tags Hide") / prop("Rollup Name Hide"), .4), "★★★★ ✓", ""))))))
Example