• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Calculate Shown Fields Without Calculating Hidden Fields

Community Beginner ,
Aug 20, 2024 Aug 20, 2024

Copy link to clipboard

Copied

I have a simple table with three columns and multiple rows. The columns are as follows:

  1. Training Course Name
  2. Checkbox
  3.  Read Only field displaying the value of the training per hour. It also has a condition to hide until the corresponding checkbox is marked, i.e. $0.25

If an employee has completed a training they can check the box it will then show the value of the training.

At the bottom of the spreadsheet I am totaling the value of all the training they have completed with a simple calculated field: [Amount 1] + [Amount 2] + [Amount 3] + [Amount 4] + [Amount 5]

I was hoping that this formula would not count the value if the field is hidden, i.e. not checked. It does not however.

Any ideas how I would change my setup to get this to work?

TOPICS
Adobe Sign forms

Views

154

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Dec 01, 2024 Dec 01, 2024

Copy link to clipboard

Copied

LATEST

Hi -leejordanjay-,

 

Thank you for reaching out, and sorry about the delay in response.

 

Please refer to the following help document for more information on calculated fields: https://adobe.ly/3CUa2Pm.

We have checked that you are using the Adobe Sign Enterprise plan. If you have questions about the calculation fields, the experts can best answer them. Please contact our Adobe Sign Enterprise support team for the correct information. You may contact them using the steps in the following help document: https://adobe.ly/3B6EuVX.

 

Thanks,

Meenakshi

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines