Hey all - I'm looking for some help creating a formula based on a "Total Contract Value" field. We collect the spend in that field, but I'm looking to create a formula that would allow different approval levels based on the value. I figure these will each need to be separate fields and then used in conditions applied to the conditional approvals, but please let me know if there's an easier way.
I was looking at If/greater than formulas but there seems to be an issue with the input types. Any assistance with creating a formula would be greatly appreciated!
Level 1 up to $10k
Level 2 up to $15k
Level 3 up to $50k
Level 4 up to $250k
Level 5 up to $1M
Level 6 up to $2.5M
Level 7 up to $5M
Level 8 up to $10M
Level 9 up to $15M
Level 10 up to $25M
