Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Use formula in conditional display of form field

Topic Labels: Views
1403 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryana
5 - Automation Enthusiast
5 - Automation Enthusiast

I have three fields in a form. The first two hold a number, the last one I want to appear only if the second number is less than x% of the first number. Is there a way for me to use a formula within the display logic to achieve this?

3 Replies 3
Kamille_Parks
16 - Uranus
16 - Uranus

The formula would be something like:

IF({field 2} < ({field 1} * .05), "what to show if less than 5%")

Ryana
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Kamille, rather than showing a value if the conditions are met, I am wanting to use this formula to decide if a field is shown in the form view

Oh, that can’t be done. The conditional form field display isn’t quite sophisticated enough to compare values to each other, only predefined values.