Create a project status button highlighting the furthest field filled in on the form

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

I am trying to create a field that simply states what the furthest field filled in on the project is.  This way when someone is looking at the projects they know that this one got to x section while another one may be at y section?

Photo of Data


  • 0 Points

Posted 3 years ago

  • 0
  • 1
If these were text fields, then you woUld just do a giant IF statement checking all the fields, from Last to first to see which is not blank.

For example
not isNull([Date Completed]), "Completed",
not IsNull([Date Started]), "In Process",
not IsNull([Date Approved]), "Approved", "Waiting Approval")