Hi Everyone
Could some on give me some direction?
I am creating a preview of a form which will be emailed (HTMLText).
I am attempting to setup that text displays based on Dropdown values.
I have done it with selecting one value but can you do it with 2 values in one IF statement
My formula currently is
&"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development", Dropdown1_1.Selected.Value)
I tried this but it doesn't work
&"<br></b>" & If(Dropdown1_0.Selected.Value="Minor Development", Dropdown1_0.Selected.Value) &"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development" Or "Safety Critical", Dropdown1_1.Selected.Value)
Any help appreciated
Gary
Solved! Go to Solution.
Hi All
I have found the solution (I am new to this lol) so this is to help the other new users 🙂
Instead of using If statements you use a Switch
Switch ( the value you want to action,
"measure", outcome,
"measure2",outcome )
in my case the example would be
Switch(Dropdown1_1.Selected.Value,
"Minor Development", DataCardKey1.Text,
"Safety Critical", DataCardKey1.Text
)
Hope this helps someone 🙂
Gary
Hi All
I have found the solution (I am new to this lol) so this is to help the other new users 🙂
Instead of using If statements you use a Switch
Switch ( the value you want to action,
"measure", outcome,
"measure2",outcome )
in my case the example would be
Switch(Dropdown1_1.Selected.Value,
"Minor Development", DataCardKey1.Text,
"Safety Critical", DataCardKey1.Text
)
Hope this helps someone 🙂
Gary
Hi @gazzo1967 ,
Thanks for sharing your resolution here and hope others could benefit from it.
Regards,
Mona
User | Count |
---|---|
229 | |
99 | |
95 | |
56 | |
33 |
User | Count |
---|---|
280 | |
110 | |
109 | |
63 | |
62 |