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?
Connect
1 Answer
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.
Without Answer
-
- 86
- 0
- 5 days ago
-
- 397
- 0
- Jun 11
-
- 855
- 0
- Jun 4
-
- 592
- 0
- May 19
-
- 249
- 0
- May 16
-
- 591
- 0
- Apr 29
-
- 610
- 1
- Mar 20
-
- 571
- 0
- Mar 14
- see all
Recent Activities
CATA asked 5 days ago
notion do not open in my Windows PCamandabee asked May 16
Display backlinks in a block or page?
...