You are viewing limited content. For full access, please sign in.

Question

Suppress value of formula before fields are populated

Forms

Updated July 20, 2022

asked on July 20, 2022

When using formulas in a table within Forms, how can you suppress values in fields that are dependent upon entry in other fields before the user enters the data? We are using version11.

0 0

Replies

replied on July 20, 2022

You can add an IF function that prevents the rest of the calculation from being applied until all the fields you want are filled.

For example, something like this

=IF(AND(INDEX(Table.Column1,ROW())<>"",INDEX(Table.Column2,ROW())<>""),CALCULATION,"")

1 0

replied on July 20, 2022

Worked beautifully. Thank you!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked July 20, 2022
Updated July 20, 2022
26 views