Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

3votes

I want to create a simple formula in column D that is based on the value in column C. If the value in column C is 0 or below 0, column D should return a green circle, if the value is below 0, it should return a red circle. May anybody help me out?

1 Answer

2votes

LamboNr5 Points910

Hi, you propably mean it it's higher than 0, it should be red. If so, here's my solution. Here's the Template:

https://salty-eyelash-037.notion.site/fd3719dc46214663a372403792d5d890?v=0272bd91478c4b979cb30b5f7925eff3

You can copy it into your Notion :)

Make sure that Column C is number Format.

The Formular is

if(prop("C") <= 0, "Large Green Circle", if(prop("C") > 0, "Large Red Circle", ""))

Get the circles here:
https://emojipedia.org/large-green-circle/
https://emojipedia.org/large-red-circle/

1vote

ecopsorn commented

Thank you so much. This worked flawlessly. I even put in another if statement so I can distinguish between the 0 and the <= zero positions. The <= zero positions are the ones I bought more than my initial plan.

1vote

LamboNr5 commented

Glad I could help. If you want more Notion content/help, feel free to add me on LinkedIn (Code: Green Circle ;) -> www.linkedin.com/in/jan-lambers

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect