You are viewing limited content. For full access, please sign in.



Dynamically disable formula

asked on June 12, 2018 Show version history

I have a field that is using a formula to be filled in.  In some cases I would like to manually fill the field in and not have the formula do it.  Is there a way to dynamically disable the formula if a checkbox is checked?


0 0


replied on June 12, 2018

Your Fields formula would have to have an IF statement to not do the Calculation if the box was checked, but instead fill the field with nothing. The form is still running just returning a NULL value.

0 0
replied on June 12, 2018

Thanks Steve, that helped!  Man I love this forum and guys like you, so helpful!  I didn't really disable the formula.  Here are some quick notes for others future reference:

To reference check boxes in an IF formula, or any other formula, the syntax is CheckBoxVariableName.NameOfBoxChecked

In my case the Check Box's Variable was ForcePassFail and I had two option to check: PASS, and FAIL.

The syntax for the IF is IF(test, pass_result, fail_result)

Here is my IF Statement:

=IF(ForcePassFail.PASS,"PASS",IF(ForcePassFail.FAIL,"FAIL", LotsOfOtherNestedIFs))

Which in pseudo code is: IF the ForcePassFail.PASS box is checked make this field "PASS", IF the ForcePassFail.FAIL box is checked make this field "FAIL, otherwise run lots of other nested if statements that I have.

0 0


You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.