ISBLANK [2 Columns]

Hello,

I wanted to LIST values based on an IFS()

LIST(
IFS(
ISNOTBLANK([ppd_am]), “AM”,
ISBNOTLANK([ppd_pm]), “PM”,
ISBNOTLANK([ppd_am], [ppd_pm]), “Full Day”
)
)

I basically want it to show AM, PM, and Full Day… But not show each one if the value is blank. It is an Enum that will or will not display each based on the values in [ppd_am] and [ppd_pm].

The issue is with ISBNOTLANK([ppd_am], [ppd_pm]), “Full Day”

How can I check 2 values?

Screen Shot 2021-05-06 at 1.43.20 PM

You’re wanting to populate your Enum options based on these ISNOTBLANK conditions, correct?

LIST(
  IFS( ISNOTBLANK( [ppd_am] ) , "AM" ) ,
  IFS( ISNOTBLANK( [ppd_pm] ) , "PM" ) ,
  IFS( AND( ISNOTBLANK( [ppd_am] ) , ISNOTBLANK( [ppd_pm] ) ) , "Full Day" )
) - LIST("")
2 Likes

WHY DIDN’T I THINK OF AND!!! lol

Thanks Marc!!!

I believe that should fix it.

1 Like