Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
5 years ago

Formula help

I have been asked to set up approval settings for users, but with stipulations.  I want to allow a user to approve a request if it is $1000 or less over budget. I have a "Remaining Budget" field, a...
Formulas and functions
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
If you're just trying to build a Formula Checkbox field, the setup is relatively straightforward. In this field type, you only have to identify what criteria makes it True (or checked). For your scenario, I would suggest this:

([Remaining Budget]-[Cost])<=1000​


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------