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?
Connect
1 Answer
Hi, you propably mean it it's higher than 0, it should be red. If so, here's my solution. Here's the Template:
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/
Recent Activities
joeythelemur commented Apr 29
How can I better organize a LOT of properties?amandabee selected an answer Apr 29
Adding a basic feedback form to pages in a Notion…amandabee answered Apr 29
In Notion, I want the “Title” column to be filled …amandabee answered Apr 29
How can I better organize a LOT of properties?
