You’re offline. This is a read only version of the page.
Hi,
I have a "Passed" or "Failed" auto output in a text card which is populated by either Passed or Failed based on whether something has been inputted, or not inputted with either "Yes" or "No".
Below is my code, however it is not showing anything within the text field which makes me believe this is because its not testing if the choice(dropdown) list has any value selected.
If(Text(DataCardValue129_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue129_1.Selected.Value),
If(Text(DataCardValue130_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue130_1.Selected.Value),
If(Text(DataCardValue131_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue131_1.Selected.Value),
If(Text(DataCardValue132_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue132_1.Selected.Value),
If(Text(DataCardValue133_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue133_1.Selected.Value),
If(Text(DataCardValue134_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue134_1.Selected.Value),
If(Text(DataCardValue135_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue136_1.Selected.Value) = "Yes",
If(Text(DataCardValue137_1.Selected.Value) = "Yes",
If(Text(DataCardValue139_1.Selected.Value) = "Yes",
If(Text(DataCardValue140_1.Selected.Value) = "Yes",
If(Text(DataCardValue141_1.Selected.Value) = "Yes",
If(Text(DataCardValue142_1.Selected.Value) = "Yes",
If(Text(DataCardValue143_1.Selected.Value) = "Yes",
If(Text(DataCardValue144_1.Selected.Value) = "Yes",
If(Text(DataCardValue145_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue146_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue147_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue148_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue149_1.Selected.Value) = "No" Or IsBlank(DataCardValue135_1.Selected.Value),
If(Text(DataCardValue150_1.Selected.Value) = "Yes" Or IsBlank(DataCardValue135_1.Selected.Value),"Passed","Failed")))))))))))))))))))))
I have also tried:
If(Text(DataCardValue149_1.Selected.Value) = "No" Or "")
But as its not a text string i think this may be why that way isnt working.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
22
