Hi Everyone,
I am using a sheet too manage and track mails received by my department , and I am having troubles defining a formula to automatically display in a symbol type column ( called Statuts ) , a ball whose coulour depends on some circumstances .
I would like to precise that I am using the French version of SMARTSHEET, so :
- the green ball is : « Vert » ;
- the red bal is : « Rouge » ;
- the yellow ball is : « Jaune » ;
- the gray ball is : « Gris »
So the formula accounts for 3 columns :
- a symbol type column which will receive the formula ;
- 2 dropdown list type columns , called « Courrier réponse » and « Traitement demande » which will take the values "Oui" or "Non" .
Therefore , the coulour of the ball will depend of the combination of the values taken both in the « Courrier réponse » column and in the « Traitement demande » column .
I typed the following formula , but it seems to be incorrect as the cell takes the value « UNPARSEABLE » :
=IF(AND([Courrier réponse]1 = "Oui"; [Traitement demande]1 = "Oui"); "Vert"; IF(AND([Courrier réponse]1 = "Oui"; [Traitement demande]1 = "Non") ; "Bleu", IF(AND([Courrier réponse]1 = "Non"; [Traitement demande]1 = "Oui") ; "Gris" ;"Rouge"))) ;
Can you tell me what’s wrong with the formula ? Any improvement suggestion ?
