My column isn't returning a value has it should

[lynnzrae]

I have the following column command. 

To my knowledge, the way it is written, if the criteria is not met (in the command), my return value should be not expired.  Therefore in this column there should either be an "expired," or "not expired," value.  However, as you can see I am getting blanks where it should state "not expired." How do I need to adjust my command to get the value "not expired" to return when the "expired" criteria is not met?

Permit Start Date Expiration =

IF(

   ( TPermitExpiration[Permit Construction Start Date] < TPermitExpiration[Construction Work Commenced Date])

        || (

            ISBLANK ( TPermitExpiration[Construction Work Commenced Date] )

                && TPermitExpiration[Permit Construction Start Date] < TODAY()

           ),

             "Expired",

             "Not Expired"

)

Construction Work Commenced Date	Permit Start Date Expiration in 180 Days	Permit Start Date Expiration	Permit Construction End Date
	Nearing Expiration		11/1/2024
	Safe From Expiration	7/20/2028
	Safe From Expiration	4/19/2028
10/1/2022	Safe From Expiration	5/19/2027

[Anonymous]

Hi, @lynnzrae 

Please refer to the screenshot.

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lynnzrae]

Yes it is.  I got the text "Expired" but I do not get the text "Not Expired."  I can't see how your formula is different than what I provided.  What did you do differently to get the "Not Expired?"

[Anonymous]

Hi, @lynnzrae 

Please see the attachment. Hope it helps.

Column = 
IF(
   ( TPermitExpiration[Permit Start Date Expiration] < TPermitExpiration[Construction Work Commenced Date])
        || (
            ISBLANK ( TPermitExpiration[Construction Work Commenced Date] )
                && TPermitExpiration[Permit Start Date Expiration] < TODAY()
           ),
             "Expired",
             "Not Expired"
)

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lynnzrae]

The text still isn't showing.  Could it be a setting somewhere?

[Gabry · Accepted solution]

Hello @lynnzrae ,

have you already tried like this?

IF(
OR(
TPermitExpiration[Permit Construction Start Date] < TPermitExpiration[Construction Work Commenced Date],
AND(
ISBLANK(TPermitExpiration[Construction Work Commenced Date]),
TPermitExpiration[Permit Construction Start Date] < TODAY()
)
),
"Expired",
"Not Expired"
)

[lynnzrae]

I realized it was a font setting but was there all along.  Thanks for the help.

[lynnzrae]

unfortunately it is still showing as blank.  Although in either formulas it will filter as not expired