Forum Discussion
If statement generates an error for blank rows
Hi,
add this before the start of you if statement
if [Status] = null then null else
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
add this before the start of you if statement
if [Status] = null then null else
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you, that worked like a charm!
Just wondering, why do I have to keep the null you suggested AND the null I had at the end? Don't they do the same thing?
No Problem,
The first checking for null is just to remove the blank error as text.contains can't start looking for anything in a null field, so we're just eliminating it using that at all.
The last null is if anything doesn't appear in you Text.contains statements it'll just return null, if you're sure that there will always be one of the values listed in the text.contains statements then you could rewrite it to remove that part.
Personally i'd keep it for potential error handling if something in the data changes.