Issues with return values on IFS() equation

AppSheet AppSheet Q&A
1

Hi everyone! I’m having some issues with an IFS() equation.

IFS(ISNOTBLANK(SELECT(Dashboard Filter[AgencyInstructionsFilter],[AgencyInstructionsFilter]=“Not blank”)), ISNOTBLANK(SELECT([Agency Instructions],ISNOTBLANK([Agency Instructions]))),
ISNOTBLANK(SELECT(Dashboard Filter[AgencyInstructionsFilter],[AgencyInstructionsFilter]=“Blank”)), ISNOTBLANK(SELECT([Agency Instructions],ISBLANK([Agency Instructions]))),
ISNOTBLANK(SELECT(Dashboard Filter,[AgencyInstructionsFilter]=“None”)),
true)

Essentially the AgencyInstructionsFilter is a filter column that supposed to filter a different table (Case Info Database) depending on if an Agency Instructions columns is blank or not. This particular equation returns no values for a filter of “Blank” and all values for filters of “Not blank” and “None”. The last filter should be the only one that returns all values. The AgencyInstructionsFilter and Agency Instructions columns are both text, with the latter being an Enum with base value of text.

I’m thinking my use of ISNOTBLANKS is messing me up somewhere but I’m just not sure. Is there anything that stands out to anyone? Thanks in advance!

Thanks,

Justin

1 Like
2

I believe that you are using the IFS() function in a way it was not made. I have linked the document for it but IFS() is supposed to be a back and forth IFS(condition1, result if true1, condition2, result if true2…) I do not see any desired outputs in your code but I see lots of conditionals.

Hopefully that helps, if it is still not making sense then seeing some examples would really help me to get everything sorted for you.

Craig

QREW Technologies

IFS()

1 Like
3

@Craig_QREW thanks for the response! Essentially I’m just trying to filter a list. If the Dashboard Filter column has x value, then I want to list all rows of y table that has a column value of z. I can provide some examples. What would you be looking to see?

Thanks in advance!

4

Your expression is all sorts of broken.

Are you using a slice?

What in the world do you think this does?

ISNOTBLANK(SELECT([Agency Instructions],ISNOTBLANK([Agency Instructions])))