ISBLANK [2 Columns]

[wrodriguez1]

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?

[Marc_Dillon · Accepted solution]

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("")

help.appsheet.com

IFS()

First-match conditional evaluation

help.appsheet.com

AND()

Are all true?

[wrodriguez1]

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

Thanks Marc!!!

I believe that should fix it.