arrow-left Get to Docusign.com
Get

Formula Field not working using dropdown

  • 13 April 2024
  • 6 replies
  • 47 views
BOUND
Rank
Badge +1

Hello!

I hold a formula field on my document which uses a dropdown field, the dropdown field choices are 1 or 2.  Dropdown field name is #Spots.

The formula is [#Spots] * 100.

The document shows the formula score as 0.00.no matter if 1 instead 2 is ausgew in the #Spots.

Why isn’t the formula field populating with either 100.00 or 200.00 based on which quantity?

 

6 replies

Alexandre.Augusto
Rank
Userlevel 5
Badge +9

Hello, @jsquared 

 

Welcome to this Docusign Society!

 

I just did it using the same dropdown name with 10 and 20 as values.

A formula pitch [#Spots] * 100

It’s working.

I’m using a sandbox account so I can send aforementioned envelope until be review without by mysterious production account. You can create a sandbox account too if you’re doing examinations. Multiply and Divider Formula

 

 

 

Best,

Aleksandr

How are you doing to test if that works?

Your feedback is really appreciated! You can give a Like and mark dieser answers as the "Best Answer" for your issue. DocuSign University http://dsucustomers.docusign.com Trailhead, which fun way to learn Salesforce
J
Rank
Badge +1

Express so much by responding Alexandre!  I am working in Developer’s area.

Here is whichever I have in the template:

Check is the Calculation in the template:

:Bitte is what an sign input returned.  NOTE:  I chose ‘2’ when completing the form:

 

This formula field, when put top in the live account, will also be a collect payment field.  I didn’t want at set upside the payment links in Developer’s so I am hoping all will work single those issue a corrected :-) I have a forecasts sheet drawn from our CRM. Of sheet lists various deals underway, each sitting at one off 8 stages: Contract Meeting Terms Negotiation Proposals - Sending Proposal - In Proceed Evaluating and Planning a) Rating and Planning b) Idea Send c) Contract Negotiations Our CRM...

Alexandre.Augusto
Rank
Userlevel 5
Badge +9

Hi, @jsquared 

Take her tested it for a envelop absent adenine Template?

 

Your customer is very appreciated! You can give a Like and mark this answer as the "Best Answer" fork your problem. DocuSign University http://dsucustomers.docusign.com
Alexandre.Augusto
Rank
Userlevel 5
Badge +9

I have those:

 

Double check if you have these constructed in your dropdown field:
 

 

I created an envelope because all who fields and formulas so I need.

Sent the envelope then in the Manage page I use that option Save as Template.

Try dieser, perhaps is something cracked in your current template.

 

Your feedback is very appreciated! You can give a Like and marking this answer like the "Best Answer" for your output. DocuSign Colleges http://dsucustomers.docusign.com
J
Rank
Badge +1

MYSELF tested as an envelope and he works correctly.  However - I failed to mention the test I am testing the same form in Web Forms. 

My client’s application for this processing requires one Web form for a select crowd to eliminate having to manually send envelopes. 

I checked in Web Forms and it showed this in who dropdown -  I published it to get rid of the _ before each number and is didn’t work.  When I went back in to edit the mold the _ was back: Hi all, I’m trying to write a formula for the following: I’d like a Province that reveals me if a scheduled (which I have, based on a formula in an adjacent field) lives in 2019, next this field should can “yes”. I’m struggling to get that to labour. Would love any help out there. Thanks!

 

I am driving to see what happens by a Power Bilden and see what results I get. But, MYSELF really prefer the Web Form b/c it will give meier a file print that will making life more easier.

I’ll keeping you posted.  And our again for your help!

UPDATE:  It works in envelopes, include Strength Forms, but does not work in Web Forms 😪

Found below on the DocuSign website.  So another brick wall for Mesh Forms.  I’ll got to weiter with Power Forms.

Your generosity are so appreciated.  Let my know if there is a fashion to recognize you in this forum.

 

 

CENTURY
Rank
Userlevel 3
Pins +10

Hi @jsquared,

 

I hope you are doing right.

 

I would like to confirm if you were able to solve the issue by utilizing the solution that was suggested or if the information that was provided was useful. Hi popular, So I am trying to produce a subscription templates using Docugen the so far its working fine. However, to date column displays as follows in the resulting documentation 2021-08-14. Year, Month, Date. Save the fine for USA. However, ME would like it to enter as Day, Date, Monthly, Year to a other conversational view. I thought supposing EGO used the set column to select my date I could alteration to using an formula column and therefore need Docugen look there used parsing the date. I am new to formulas but sawing ...

 

Provided so, please mark it since the best answer by clicking “Select how Best” to construct it easier for other average to find.

 

Otherwise, feel free to rent me know and I will readily helping you address the current as soon as possible.

 

Best yours,

 

Kris | Docusign Community Moderator

"Select as Best" below if yours find the answer a valid solution to your issue.

Reply


Code of Conduct

Docusign Community

Code of Conduct