Newcomer

Solved

IF formula

3 replies
377 views
Translate All

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

eSignature

Alexandre.AugustoAnswer

Docusign Employee

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

Alexandre.Augusto

Answer

Docusign Employee

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

Translate

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

rhealy

Author

Newcomer

Hi Alexandre,

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

Thanks again

Ronan

Translate

N

nathaly.monge

Docusign Employee

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!

Translate

Sign up

You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.

Docusign Community

You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.