please help

[Mya2015]

if [TB03_Date]="NotFound" and [AFB Date] ="NotFound" and [#"Pre-TB Date"] ="NotFound" then "Nottest"

else [TB03_Date] else [AFB Date] else [#"Pre-TB Date"]

Someone suggesstion me

[spinfuzer · Accepted solution]

Replace all these columns "NotFound" with null

Then use formula

[TB03_Date] ?? [AFB Date] ?? [#"Pre-TB Date"]

below works too if you want it to say All Not Found if all are null

[TB03_Date] ?? [AFB Date] ?? [#"Pre-TB Date"] ?? "All Not Found"

You could also do 

[BA_Pete]

WOW!

I cannot for the life of me work out how you've managed to translate OP's question into this answer.

OP seems happy with the solution though, so good job!

Pete

[BA_Pete]

Hi @Mya2015 ,

Happy to help if you can explain what you're trying to achieve.

What, exactly, are you expecting this formula to do for you?

Pete