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
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
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
-
- 13
- 0
- 8 hours ago
-
- 200
- 1
- Sep 4
-
- 156
- 1
- Aug 26
-
- 448
- 1
- Jul 4
-
- 644
- 1
- May 14
-
- 492
- 1
- May 9
-
- 527
- 1
- May 4
-
- 331
- 1
- Apr 25
- see all
Exclusive for Notion Answers Users
- • Dynamic Calendar Icon | Info | Download
- Add yours here
Recent Activities
amandabee asked 8 hours ago
Anyone using the Ubuntu Snap Notion app?thomas_yang answered 1 day ago
Relationship Properties on automations, how do the…Sandvich answered 5 days ago
Creating automated numbering for data entries in d…notionhq selected an answer 5 days ago
Format image to fit cell in tablenotionhq selected an answer 5 days ago
help to to a formula on notion on a subtract matte…
...