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/
Related questions
- How to return a value in another column by using an if-statement?
- I need help with my progress tracking bar
- How to create a new database item based on a trigger status in another database
- A formula reflecting a checked box if more than one option is selected from another "multiselect" column in a database?
- How to use multiple if statements in one formula to return words based on tags
Without Answer
-
- 89
- 0
- 1 day ago
-
- 72
- 0
- 5 days ago
-
- 479
- 0
- Apr 29
-
- 444
- 1
- Mar 20
-
- 452
- 0
- Mar 14
-
- 400
- 0
- Feb 21
-
- 391
- 1
- Feb 14
-
- 450
- 0
- Feb 13
- see all
Recent Activities
jcarminio asked 1 day ago
Thoughts on adding Notion AI's web search access i…amandabee asked 5 days ago
Display backlinks in a block or page?amandabee answered 5 days ago
Counting Stars?polle answered 6 days ago
Counting Stars?amandabee answered May 13
settings of font colour changed?
...