arrow-left Back to Docusign.com
Question

IF formula

  • 26 April 2024
  • 3 replies
  • 19 views
R
Rank
Badge +1

 

Hi,

I have 2 dropdowns.

I want a text box to show a different output based on what the requestor chooses in the 2 dropdowns.

Say the requestor chooses CITIBANK in dropdown 1, and EURO in dropdown 2

I want the text box to say “CITIBANK EUR BANK DETAILS ARE 123546456”

In Excel, it would be something like “If(AND(A1=”CITIBANK, B1=”EUR”),<details>,0)

I can’t seem to figure out the logic required to do this using the DocuSign conditional fields and formula fields. Any help would be appreciated, thanks

3 replies

Alexandre.Augusto
Rank
Userlevel 5
Badge +9

Hello, @rhealy 

 

Welcome to the Docusign Community!

 

Using two dropdown boxes at same time as you would like, will not work to hide/show a specific text field.

 

I think a workaround could be this one that I tested:

  • Create a checkbox with the possible options to be selected by the signer
  • In each individual checkbox add a text option combining Citibank and the currency
  • Make the the Checkbox grous validates at least one required option
  • Create a conditional rule for each checkbox option to show a specific text field
  • Create the correspondent text fields that matches the combination chosen by the signer

See this example:

 

Perhaps this workaround will solve your question. 

 

I hope that helps!

Best,

Alexandre

Your feedback is very appreciated! You can give a Like and mark this answer as the "Best Answer" for your issue. DocuSign University http://dsucustomers.docusign.com
R
Rank
Badge +1

Hi Alexandre, 

 

Thanks for your reply. That makes sense and should work as a solution. 

 

Thanks again

Ronan

N
Rank
Userlevel 3
Badge +9

Hello @rhealy ,


If you found the provided response to be a useful solution to your question, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find.


Best regards,

Nathaly | Docusign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue!

Reply


Code of Conduct

Docusign Community

Code of Conduct