Skip to main content
How do I set up formula to flag the following: IF (Value1 > Value2 by 200) OR IF (Value1 < Value2 by 200), THEN flag both values in red ???

Hello,

Thank you for reaching out here in the DocuSign Community.

Sure, however, to better understand what you are asking, I would need a little more information to be able to provide the correct answer for you.

Can you elaborate on what you mean by "flag both values in red"? Do you want the values to turn a red color? Or is it just the outline of the box the values are in you want it to turn red? What would be those values?

Also, in the following link you can find information on the IF function for formulas: https://support.docusign.com/s/document-item?bundleId=gbo1643332197980&topicId=mnf1578456360259.html&_LANG=enus

Let us know if you need further assistance with this.

Best regards,

Nathaly | DocuSign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue!


Thanks for replying.

Would like to implement a hidden logic field that would compare the 2 values. If the difference between the values is 200 or less, then the values maintain same coloration. However, if the difference between the values is greater than 200, then the values turn red.

Sounds like it would be a combination of a Formula and a Conditional setup, but I am new and unsure how to correctly insert the formula.


Hello,

Thank you for reaching back.

Thank you for the clarification, unfortunately, that is an advanced formula you are trying to create, and to accomplish this you would need the assistance of our Professional Services Team (which has an extra cost). If you are interested, please create a case with Customer Support: https://support.docusign.com/en/contactSupport 

If you’re not able to open a Customer Support case via the above link, you can scroll down the page to “More Support Options” and select "I can't reset my password or don't have an account." You will have different options to contact Support.

Let us know if you need further assistance with this.

Best regards,

Nathaly | DocuSign Community Moderator

"Select as Best" below if you find the answer a valid solution to your issue!


Reply