Question

Hey sup! making like a price list, i wanna make like two fields/blocks, one of them should be how much £ with the ones with the status column marked as Yes. The other should b the £'s added up for the ones marked as No. how'd i do this?

Answer 1

An easy way is to create two new properties using Notion formulas to have the sums separately.

New property Yes

if(prop("Purchase") == "Yes", prop("Price"), 0)

New Property No

if(prop("Purchase") == "No", prop("Price"), 0)

Then at the bottom of both new columns you can select "Sum" in the Calculate options. Also you can rollup that information into other databases if needed.

Hope that helps.