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
-
- 85
- 2
- 5 days ago
-
- 71
- 0
- Jan 30
-
- 105
- 1
- Jan 23
-
- 112
- 0
- Jan 16
-
- 97
- 0
- Jan 15
-
- 128
- 1
- Jan 6
-
- 91
- 1
- Dec 30, 2024
-
- 150
- 1
- Dec 30, 2024
- see all
Exclusive for Notion Answers Users
- • Dynamic Calendar Icon | Info | Download
- Add yours here
Recent Activities
notionbackups answered 17 hours ago
Where does notion keep my data?sydann04 commented 3 days ago
Created Views Not Showing in Linked Databasethomas_yang commented 4 days ago
Created Views Not Showing in Linked Databasesydann04 asked 4 days ago
Created Views Not Showing in Linked Database
...