Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom Column - handle comparing multiple null columns

I have 15 columns. I want to create a custom column that checks if all 15 columns are not NULL to output either Complete or Incomplete

 

My logic is something like:

=

[ID] = null
or [NAME] = null
or [Application] = null
or [Application Type] = null
etc etc
then "Incomplete"
else "Complete"
 
But I always get Incomplete even though there are multiple rows with everything filled in.
 
Any ideas on how to structure that logic?
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    Hi Anonymous,

     

    with the function ISBLANK you can check if there is any value.

     

    BLNK =
VAR AnyBlank =
    ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] )
        || ISBLANK ( TestTable[Column3] )
VAR Result =
    IF ( AnyBlank; "Incomplete"; "Complete" )
RETURN
    Result

     

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Can you post some sample data? 

     

    • Nolock's avatar
      Nolock
      Resident Rockstar
      7 years ago

      Hi Anonymous,

       

      with the function ISBLANK you can check if there is any value.

       

      BLNK =
VAR AnyBlank =
    ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] )
        || ISBLANK ( TestTable[Column3] )
VAR Result =
    IF ( AnyBlank; "Incomplete"; "Complete" )
RETURN
    Result

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nick, I attached the sample table and sample formula i'm using

      • Nolock's avatar
        Nolock
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        please check the 3rd message of this thread if it is the solution you expect. We published our post in the same time and maybe it was overseen.