need help creating a formula

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Here is what I need to create:

if(date paid) is on or before (due date) then (credits earned)=1 

here are my fields:

date due

date paid

credits earned

Photo of DelRay

DelRay

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
If the credits earned field is a formula numeric field type then the formula will be

IF([date paid] <= [due date],1,0)