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
------------------------------ - I spoke a bit too soon...
All working except the last two lines which are just receiving "no recorded decision"
These two:
[Batch Type]="CSS Decline", "Declined",
[Batch Type]="CSS Recommend", "Accepted",
------------------------------
Owen Morgan
------------------------------- Owen,
Any chance of spelling error against the data source?
CSS Declnie instead of CSS Decline
Matching text is challenging for strings as we read what we want to see and the computer reads what is actually there.
Also if there is an extra space: CSS Decline is not CSS Decline
Your logic should be good, I suspect it is syntax.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------Thank you
Right again – it was CSS-Decline – my mistake!
Funny how you can stare at something so long and not see the error
Owen
------Original Message------
Owen,
Any chance of spelling error against the data source?
CSS Declnie instead of CSS Decline
Matching text is challenging for strings as we read what we want to see and the computer reads what is actually there.
Also if there is an extra space: CSS Decline is not CSS Decline
Your logic should be good, I suspect it is syntax.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
