I want to show custom message instead of "no items". But the show is not happening here.
IF(
CONTEXT("View") = "Pendency", "Great ๐",
IF(
CONTEXT("View") = "Same-day Report", "Awaiting for Scanning",
IF(
CONTEXT("View") = "bad stock", "Today No Scan Data Found",
"No Items"
)
)
)
Solved! Go to Solution.
Have you solved this?
I think it's a "bug". I try to put two different values to translate text in my apps, and the same issue occurs. Maybe it's not possible yet?
The expression looks okay to me, have you tried to use SWITCH() to see if resolves ?
SWITCH(
CONTEXT("View"),
"Pendency", "Great",
"Same-day Report", "Awaiting for Scanning",
"bad stock", "Today No Scan Data Found",
"No Items")
Sometimes when I use IF(IF()) or IFS() the AppSheet doesn't show any error in the formula, but it doesn't usually work correctly either
https://support.google.com/appsheet/answer/10107700?hl=en
Have you solved this?
I think it's a "bug". I try to put two different values to translate text in my apps, and the same issue occurs. Maybe it's not possible yet?
Working here but there is a problem. In the dashboard slices only No items are visible. And when I make the slice view full, it looks correct.
Vielleicht hilft dieses kurze Video weiter: How to Create a Pop Up Help Info
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |