Hello! I'm wondering if it's possible to change the color of text based on the value from a nested If statement? I'm building a survey and based on a nested If statement, 3 answers are possible, which will in turn populate a Status field. If the facility is over capacity, I'd like the text to be Red, if at Capacity, Yellow, and if Below Capacity, Green.
~Nikki Eiden, AZ Dept. of Health Services
I tried the syntax provided in a form and it worked.
And this is the output form.
I assume your nested IF statement is working as it should. See what happens if you add a "name" to your Status note.