Confiforms - Formula Field type - Expression

[Sándor Szauer]

Hello Guys, 

I would like to have a field which gives me the string value "To be revised" if end date of a contract is in 2 months and it's "fixed term" (type==1) OR if the type of the contract is "open-ended" (type==2) and 3 years passed after start date of the contract, otherwise the value should be "Actual". It should also have an "Archive" state if the field "coordinator check" would change to "Archive" (cooCheck:5) .

I have a Formula field and I have the following expression which works for the first part. I got actual and to be revised as I expected: 

IF ([entry.validUntil]<([now]+5184000000)&&[entry.type]==1,"To be revised",

IF([entry.type]==2&&([entry.validFrom]<[now]-94670778000),"To be revised","Actual"))

But I can't arrange, that the Field gives me "Archive" state. 

I tried a lot of things, this one for last time: 

IF ([entry.validUntil]<([now]+5184000000)&&[entry.type]==1,"To be revised",

IF([entry.type]==2&&([entry.validFrom]<[now]-94670778000),"To be revised"

IF([entry.cooCheck]==5,”Archiv”,"Actual")))

But it gives me the failure:

Expression: [IF (-598755600000<(1715155245175+5184000000)&&2==1,"To be revised", IF(2==2&&(-472266000000<1715155245175-94670778000),"To be revised" IF(2==5,”Archiv”,"Actual")))] could not be calculated, Unknown operator '”' at position 150

Can somebody @Alex Medved _ConfiForms_  maybe help me? 

Thanks a lot. 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Sándor Szauer 

You need to nest your IF statements

A bit hard for me to understand the whole logic you need/have, but the expression construction should be like this

IF ([entry.a]<0, "Fail", IF([entry.a]>30, "Over", "Good"))

See the nesting in IF conditions...

Alex