Creating a two-condition formula in Notion: How to proceed?

Other Questions Notion
1

I’m trying to set up a formula in Notion that checks two select fields. The fields are called ‘Design Status’ and ‘Spec Status’. I want the formula to show ‘Start Coding’ when both fields are set to ‘Complete’. Here’s what I tried:

if(prop('Design Status') == 'Complete' && prop('Spec Status') == 'Complete', 'Start Coding')

But Notion keeps telling me there’s an error: ‘Not enough arguments for if function’. What am I doing wrong? Is there a better way to write this formula? I’m pretty new to Notion formulas, so any help would be great. Thanks!

2

hey, i’ve dealt with this before! ur missing the third argument in the if function. try this:

if(and(prop(‘Design Status’) == ‘Complete’, prop(‘Spec Status’) == ‘Complete’), ‘Start Coding’, ‘Not Ready Yet’)

this’ll show ‘Start Coding’ when both r done, n ‘Not Ready Yet’ otherwise. hope it helps!

3

I’ve run into this exact issue before, and it can be frustrating! The problem is that the ‘if’ function in Notion requires three arguments: the condition, the result if true, and the result if false. You’re missing that last part. Here’s how I fixed it:

if(and(prop('Design Status') == 'Complete', prop('Spec Status') == 'Complete'), 'Start Coding', '')

This will display ‘Start Coding’ when both conditions are met, and show nothing otherwise. If you want to display something else when the conditions aren’t met, just replace the empty string with your desired text.

Also, I found it helpful to use the ‘and’ function to combine multiple conditions. It makes the formula easier to read and modify later on. Hope this helps you out!

4

The issue lies in the structure of your ‘if’ function. Notion requires three arguments for it to work correctly. Here’s a revised version that should solve your problem:

if(and(prop('Design Status') == 'Complete', prop('Spec Status') == 'Complete'), 'Start Coding', 'Not Ready')

This formula will display ‘Start Coding’ when both statuses are complete, and ‘Not Ready’ otherwise. You can adjust the last argument to show any message or leave it blank (‘’) if you prefer no output when conditions aren’t met.

Remember, the ‘and’ function is crucial for combining multiple conditions efficiently in Notion formulas. It’s a good practice to get familiar with for more complex formulas in the future.