Hi Jeff,

I think Nick gives an excellent example of how you could go about implementing the formula you are looking for. Getting started in Quick Base and learning how to make use of fields and formulas together can involve some adjustment from other programs. We do have some resource that can help you get familiar with Quick Base. We have our E-Learning resource

Quick">https://university.quickbase.com/">Quick Base University which includes some videos and resources on formulas under our Intermediate level material. We also have our

Formula">https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6">Formula Reference guide which goes over the formula functions and their syntax for Quick Base. These two resources can help when you are beginning to build up your skills in Quick Base and tackling formulas.

Nick is correct that the first thing you need is a field created to hold that formula, that will then also display that formulas results. Then from there you can tinker and build out your formula to combine fields, run math, and many other functions depending on your needs. The key is to make sure the formula field type matches the output you want from your formula (Text for Text, Date for Date, etc). I hope these resources help as you continue on with formulas.