Toggle values
AnsweredHi, very new to this but the tool is really good.
I am trying to update 2 pages from same worksheet, 1 page needs to have Toggle to update other fields but the second does not! However, when in app mode I change over selection via toggle, the second sheet changes to n/a values.
I may be doing something wrong so some guidance would be great.
-
Official comment
Dear Prakesh.
An error of this type indicates that the value could not be found in your data source.
So you have a selection field in the Excel / App and if you select a value there, a suitable result will be displayed in another cell, correct?If the result is not displayed, it can have several reasons. Please have a look at this article to find out what to look out for in Excel. Especially interesting will be point 11 with the unsupported formulas. Do you use one of them? https://support.openasapp.net/hc/en-us/articles/209427425
How is your toggle configured? Are you using the data validation to cells in your Excel (https://support.office.com/en-ie/article/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249)
Hope we can solve the problem.
Best regards,
Damian
Comment actions
Please sign in to leave a comment.
Comments
1 comment