Hello, I am currently working on a from for a sharepoint library. Part of the form has a field that is calculated by a rule:
IF Field A > 800+ Field 2 *100
Set field 3 to > Condition.
My problem is if the numbers change, field 3 does not recalculate to a lesser value, only if it's a greater than value as stated above.
Is there a work around? I've tried using direct formulas, but end up with a false and true instead of an actual number.
Any assistance is appreciated.