Hello,
I want to create a this formula,
If Field 1 < 3 Then Field 2 = Red
If Field 1 > 3 And Field 1 < 10 Then Field 2 = Orange
If Field 1 > 10 Then Field 2 = Green
I wrote this formula on zoho :
If(And(${Contacts.Field1}<3),'Red',''),
If(And(${Contacts. Field1}>3,${Contacts.Gestion du stress}<10),'Orange',''),
If(And(${Contacts.Field1}>10),'Green','')
Problem is, if Field1 = 9 for example,
I get this answer :
','Orange','
I just want : Orange