I have several different subtask fields. The beginning part of my formula works, but after the first condition nothing else works.
Here is the beginning of my formula:
Case ([Administrative Subtasks], "Travel Time", "Travel Time", "Desk Time", "Desk Time", "Personal Appt", "Personal Appt",
I need this to work for all ["" subtasks].
It does not seem to accept any other part of the formula.
CAHPS should say Data Entry
Employer Groups should say Employer Group Client Meetings
Professional Management should say Attend Training.
I could give you my entire formula, but it is very long. Let me know. Thank you.
Case ([Administrative Subtasks],
"Administrative", "Travel Time",
"CAHPS", "Data Entry",
"Employer Groups", "Employer Group Client Meetings",
"Professional Management", "Attend Training")
Attached is the entire formula. There are no errors with the formula, according to QB, but it is not performing.
Let me know if you would like any other screenshots.
I think that what you are saying is that you have a record with about a dozen or so multiple choice fields which you call your SubTasks. You want any nonm blank data entry into these doxzen or so fields concatenated into one field.
The List function describe here will separate non null text fields with a delimiter.
So I think what you want is this
[CAHPS Activities Subtasks],
[Case Management Subtasks],
[Committee Meetings Subtasks],
[Compliance Activities and Work Plan Subtasks],
[Department Admin Support Subtasks],
[Employer Group Reports Subtasks],
[HEDIS Activities Subtasks],
[Internal Meetings Subtasks],
[Marketing and Sales Activities Subtasks],
[NCQA Activities Subtasks],
[Performance Management Subtasks],
[Professional Management Subtasks],
[Program Development Subtasks],
[Project and RIE Management Subtasks],
[QI Work Plan Subtasks],
[Quality of Care Concerns Subtasks],
[STARS Activities Subtasks],
[Time Tracking Subtasks],
[Utilization Management Subtasks],
[Vendor Management Subtasks])
Paste that into a field and let me know if that is what you are after. if it is, please double check that I did not miss any of your data entry SubTask fields.