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 Recommend, (empty))
2. [Accepted?] (boolean)
3. [Declined?] (boolean)
The new field [new batch type] can be one of 4 options ("Accepted", "Declined", "For Discussion at Update Meeting" or "No Recorded Decision"
I want to post the [batch type] in this box but if one of the booleans is ticked, allow that to override the original.
I created a new field that switches the boolean to text ("Accepted", "Declined", "AcceptedDeclined", (empty)) so that they were all text fields and we just had to look at two fields. I created this but it is not working...
If(
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="", "Declined"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="", "For Discussion at Update Meeting"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="AcceptedDeclined", "For Discussion at Update Meeting"),
[Batch Type]="" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="CSS Decline", "Declined",
[Batch Type]="CSS Recommend", "Accepted",
"No Recorded Decision")
I also tried the embedded IF with the booleans too but that didn't work either.
What am i missing?!
------------------------------
Owen Morgan
------------------------------
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 Recommend, (empty))
2. [Accepted?] (boolean)
3. [Declined?] (boolean)
The new field [new batch type] can be one of 4 options ("Accepted", "Declined", "For Discussion at Update Meeting" or "No Recorded Decision"
I want to post the [batch type] in this box but if one of the booleans is ticked, allow that to override the original.
I created a new field that switches the boolean to text ("Accepted", "Declined", "AcceptedDeclined", (empty)) so that they were all text fields and we just had to look at two fields. I created this but it is not working...
If(
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="Declined Unless Challenged" & If([Accepted or Declined]="", "Declined"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="", "For Discussion at Update Meeting"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="For Discussion at Update Meeting" & If([Accepted or Declined]="AcceptedDeclined", "For Discussion at Update Meeting"),
[Batch Type]="" & If([Accepted or Declined]="Declined", "Declined"),
[Batch Type]="" & If([Accepted or Declined]="Accepted", "Accepted"),
[Batch Type]="CSS Decline", "Declined",
[Batch Type]="CSS Recommend", "Accepted",
"No Recorded Decision")
I also tried the embedded IF with the booleans too but that didn't work either.
What am i missing?!
------------------------------
Owen Morgan
------------------------------
