Skip to main content
Question

Formula help

  • January 5, 2021
  • 0 replies
  • 18 views
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
------------------------------
This topic has been closed for replies.

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/
------------------------------
Terms & ConditionsAccessibility statement