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, and I have a Cost field. What I'm not sure of is how to go about saying that if the difference between the fields is $1000 or less, then check this box...

Can anyone help? 

Brandy Nunes

------------------------------
Brandy Nunes
------------------------------
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/
    ------------------------------