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 |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |