Get help from other Notion users

It's free & easy

Receive points, vote and give the solution

# Formula help - symbol in column based on another columns numeric value

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?

LamboNr5 Points890

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 Nov 2

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 Nov 2

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