Hello guys,
In google sheet, I have a column which shows a percentage. When there is an error in the formula I setup IFERROR so that it gives a blank result.
In the app, I want to show the text “N/A” whenever there is a blank in said column.
So far I tried these options, none of which worked:
Valid_if: ISNOTBLANK([_THIS])
Invalid value error: “N/A”
Valid_if: ISNOTBLANK([_THIS])
Invalid value error: [_THIS]=“N/A”
IFERROR result in google sheet: “N/A”
Valid_if: [_THIS]<>“N/A”
Invalid value error: “N/A”
Do you have any Idea of what I’m doing wrong?
Thanks!
@Caterina_Pampolari
You cannot display another value in a detail or table view if the column value is blank.
@Caterina_Pampolari Why don’t you use a string with the IFERROR so it would show that with the app?
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |