How to add spreadsheet fields to form calculation?

  • Profile Image
    admin_gbc
    Asked on January 03, 2022 at 02:11 PM
  • Profile Image
    Christopher_T
    Answered on January 03, 2022 at 04:54 PM

    Unfortunately, we cannot add conditional logic with the Spreadsheet widget.

    Please share with us details of your requirements so that we can look for other alternatives or workarounds.

    Looking forward to your reply.

  • Profile Image
    admin_gbc
    Answered on January 03, 2022 at 05:40 PM

    I am wanting to add the total fields from the spreadsheet into the calculation field. 

    See form elements below

    1641249607_61d37b4704249_

  • Profile Image
    Yau_C
    Answered on January 03, 2022 at 10:25 PM

    Hi,

    You cannot pass the value from spreadsheet widget to another field, but you can calculate the total

    from within the widget:

    1641266636_61d3bdcc5eb53_

    C3 = c1 +c2 gives you the sum of total.