How to have a formula with if error

Looker Q&A Looker Studio
1

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 ?

2

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
)