Re: Set a text box value based on 2 different calculated fields

Hilary Stoupa — Thu, 31 Mar 2016 14:41:32 GMT

Hi - your screenshot isn't displaying for me. You can attach it to a reply under the Options tab. I think you maybe just need rules on both the fields with your category scores to reset field Y, since both of those fields are part of the comparison.

Set a text box value based on 2 different calculated fields

BenG20 — Mon, 28 Mar 2016 13:36:50 GMT

Good Morning!

I would love some help with some conditional formatting. I have a form that is based off of a SharePoint 2010 List. The form consists of a bunch of drop down boxes. Based on the users selections I assign a value to their answer. Then using hidden fields I total the scores up into two categories. No problems there. I have tested the form out and am getting the correct scores for 2 different categories. I then have to compare the final scores for category A and category B, and depending on the range the scores fall into I have to assign a value to a text box. Basically I'm trying to duplicate the following matrix

So basically if the total score for category A falls between 0-83 AND the total score for Category B falls between 0-166 set field Y to "Bad"

I've attempted multiple things - but keep running into problems. Any help would be appreciated!

Newbie Questions

Re: Set a text box value based on 2 different calculated fields

Set a text box value based on 2 different calculated fields