Hello AppSheet Community,
I would like the editor to check every single one of these IFS statements. I tried putting them in OR() or SWITCH() statements but that didnโt work. How do I write this expression? Thank you.
-Tiffany
An IFS() function will only evaluate until it finds the FIRST true condition and then returns the associated value expression.
If you intention is that only ONE of the SELECT()'s be evaluated and returned then the IFS() epression would be like this:
IFS(
[Use Mandatories?]=false, SELECT(masterDatabase[Client Name], ...),
[Palm Beach?]=true, SELECT(masterDatabase[Client Name], ...),
[Mandatory AM Broward?]=true, SELECT(masterDatabase[Client Name], ...),
...
[Naples?}=true, SELECT(masterDatabase[Client Name], ...),
true, SELECT(masterDatabase[Client Name], true)
)
The last line is a default if none of the above evaluate true. It is strongly recommended you always have a default.
Based on the wording of your post, I question if this is your intention. If you are trying to achieve something else, then please elaborate on your desired result.
Thank you @WillowMobileSystems
I tried again with this expression
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |