Question

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.

Answer 1

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

Answer 2

Do this

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

This way it will show you what is in the property if it is not Random. It could give you a better idea of what is going on.

If it says "Random"... I would create a new entry for Random. I would put the formula in a plain text editor. Copy and paste it into the formula. Make sure the cursor is all the way to the left. The reason for these suggestions is because sometimes you will get invisible characters. Putting the formula into a plain text editor and pasting it back in gets rid of the invisible characters

The reason the person