limit input value how to set

IceCream

Dear friends, I want to add a constraint to the left and right input values ​​corresponding to the line items. If they exceed 100, an error will be reported. Is there any good way?

SriNitya

hi
Case 1: Sum of left and right are greater that 100 you can create a line item of text format and then you can display desired error message and can apply conditional format as well.
Case 2: Individual limits if entered greater than 100 also you can display error by creating line items.

Screenshot for reference

Hope it helps.

1636583

Hi,
you can sum both right and left values in 3rd line item(Number Format)
if right+left >100% then 1 else 0, then use this 3rd line item as conditional formatting to highlight right and left fields.