IF AND Statement error

[Litlle_red_trucks]

Hi,

I'm hoping that may be able to help me with writing a formula.

I have a couple of fields that I want met to insert data into a new field, when I write them as separate formulas they work correctly but when I try to join them using AND I receive an error, example below.

I can't for the life of me work out what's going on, any help is appreciated.

[fmvizcaino · Accepted solution]

Hi @Litlle_red_trucks ,

You got it almost right! The only problem is your if, you don't need to write an 'if' to every comparison in a clause. So the right way is:

IF [Real Node] = 'Interval' and [Task] = 'Deliver Product'

then 'yes'

else null()

endif

Let me know if that works for you.

Best,

Fernando Vizcaino

[Litlle_red_trucks]

OMG! 

Thank you so much, I knew it would be something simple (it always is) but for some reason it takes me forever to work it out.