I have a "Invoice Total" field that the user inputs a dollar value. I want to set a Calculated Value field based on the dollar value like this:
|Invoice Total Field||Calculated Value Field|
|$0 up to $50,000||Stage1|
|$50,001 to $250,000||Stage2|
|$250,001 to $500,000||Stage3|
|$500,001 to $1,999,999||Stage4|
|$2,000,000 and over||Stage5|
For Example, if the user inputs a Invoice Total of $73,000, I'd want the calculated value field to display to "Stage2" etc.
What would be the best way to achieve this in the form?
Best answer by AleximoView original