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



Notion formula for rollups return false when it is true

I have a Notion table with some properties and I need a formula to watch 5 properties (rollups) to determine if they are equal to something.

if(prop("My Property") == "Random", "It is", "It is not")

But I get "It is not", even when the value it is actually "Random" in my property. It is a rollup property and I don't know what the problem is.

Any ideas how to make this Notion formula work?


1 Answer


avidnotionuser Points1410

I would look at what is the property field type for "My Property"
For example: if(prop("Status") == "Random", "It is", "It is not")
I had Status be a select property type.

if(prop("Property 2") == "Self-Care", "It is", "It is not")
"Property 2" was the rollup property and the "Self-Care" was a select property from the relational database (roll-up).


nosy commented

It is not clear what are you suggesting here.

1- I have a Rollup and it is "My Property".
2- That rollup says: "Random".
3- The formula says false when it is true.

That is the problem. I am not looking to use select instead of the rollup. I am looking to make things work as I have them.

Thanks for the help.

Please log in or register to answer this question.


Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!