AnsweredAssumed Answered

Create a calculated field based on results of multiple calculated fields data

Question asked by Jtmwalk on Feb 13, 2016
Latest reply on Feb 13, 2016 by Jtmwalk

I need to track "current" driver status based on status of 6 other fields in a record. I am trying to create a single field that would show a line status as a number, depending on whether certain criteria on the record is filled in or not. 

As an example, some of the fields that I use a formula on are:

Date

Dispatch Tme

Driver#

Arrive

Depart

 

How can I create a single calculation field that will update anytime any data changes, and based on 6 different formulas.

Line Status Field =

i.e. If ( Not IsEmpty(Date) and Not IsEmpty(Driver#) and IsEmpty ( Dispatch Tme ); 1)

     If ( Not IsEmpty(Date) and Not IsEmpty(Driver#) and Not IsEmpty ( Dispatch Tme );2) etc.

I tried to evaluate the calculation in the options, but will not accept multiple If / Then statements.


I must be over looking the forest here - can someone lend me a hand in resolving?

Thank you all in avance

Outcomes