Notion Answers

Get help from other 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

3votes

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?

Thanks.

1 Answer

1vote

avidnotionuser Points1110

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).

0vote

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.

Exclusive for Notion Answers Users

...

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!

Connect