Question

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?

Answer 1

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/