limit input value how to set

IceCream
IceCream
in Intelligence
image.png

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?

Tagged:

Answers

  • SriNitya
    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

    image.png

    Hope it helps.

  • 1636583
    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.

Categories