Discussions

 View Only
  • 1.  Formula help

    Posted 01-05-2021 11:57
    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
    ------------------------------


  • 2.  RE: Formula help

    Posted 01-05-2021 12:58
    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/
    ------------------------------