How to have a formula with if error

[aurelie_pilette]

Hello,

I have a field like "Sprint" in which the values can be  empty, Bugs à spécfier, Friday,  SprintXX.24-09/09-SFRA

I would like to create a caculated formula like : 

if sprint is not empty and != Bugs à spécifier or != Friday, DATE(2024, LEFT_TEXT(RIGHT_TEXT(Sprint, 13), 2), LEFT_TEXT(RIGHT_TEXT(Sprint, 10), 2)) else date is empty

So, do you know how can I make that please ?

[sam8]

I think you're really close!

I was able to write the following formula and it verified correctly. 

if( ( sprint is not null) AND (sprint != "Bugs à spécifier") AND (sprint != "Friday"),
  DATE(2024, LEFT_TEXT(RIGHT_TEXT(sprint, 13), 2), LEFT_TEXT(RIGHT_TEXT(sprint, 10), 2)),
  null
)