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
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
------------------------------
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
------------------------------
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
------------------------------