Skip to main content
Participant
April 30, 2020
Question

Need help with an additional validation script for multiple (A+B) X C calculations

  • April 30, 2020
  • 1 reply
  • 353 views

Ok, so my D1, D2, & D3 columns all have the same calculations, but only one of these columns will be used per row.  My overall form has 6 "Polygon" rows.  I would like to create the form where any row can be used for any of the D columns.   I tried to use the simplified field notation calculation, but obviously it duplicates the answer (I didn't bother to format the last 3 boxes yet).  I ran into a similar issue earlier (with division), and it was resolved with a validation script (which someone graciously provided to me).  I am too ignorant to extrapolate that solution into this problem though...someone please help!

 

Thanks in advance

This topic has been closed for replies.

1 reply

Chris5730Author
Participant
April 30, 2020

I should also add that column D1 will only apply when column B is a negative value. Column D2 will only apply when the Proximity Factor column is utilized.