if text formula
Hello I am importing Data where there are 3 fields that need to combine to one. The 3 fields are 1. [Batch Type] (Decline Unless Challenged, For Discussion at Update Meeting, CSS Decline, CSS Rec...
Forum Discussion
Owen,
You have to keep you if statements in the format of
Condition, Result, Other Result
If(
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="", "Declined",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="", "For Discussion at Update Meeting",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="AcceptedDeclined", "For Discussion at Update Meeting",
[Batch Type]="" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="CSS Decline", "Declined",
[Batch Type]="CSS Recommend", "Accepted",
"No Recorded Decision")
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You have to keep you if statements in the format of
Condition, Result, Other Result
If(
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="Declined Unless Challenged" and [Accepted or Declined]="", "Declined",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="", "For Discussion at Update Meeting",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="For Discussion at Update Meeting" and [Accepted or Declined]="AcceptedDeclined", "For Discussion at Update Meeting",
[Batch Type]="" and [Accepted or Declined]="Declined", "Declined",
[Batch Type]="" and [Accepted or Declined]="Accepted", "Accepted",
[Batch Type]="CSS Decline", "Declined",
[Batch Type]="CSS Recommend", "Accepted",
"No Recorded Decision")
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Success!! thank you
------------------------------
Owen Morgan
------------------------------
------------------------------
Owen Morgan
------------------------------