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.
