I have been digging around the forums for an answer to this, and wondering if someone can help me with a creative solution here or point me to a similar problem.
I am trying to set out a work flow that is automated, and checked off when a new “Student Note” is submitted” So here is the flow: If “Services” = “1 qEEG”, the flow should be as follows:
- qEEG 1
- Report1
- ROF1
- Finished
If “services” = Pre & Post” or “4 Part”
- qEEG 1
- Report1
- ROF1
- qEEG 2
- Report2
- ROF2
- Finished
So for example, if someone submits a “Student Note” as “qEEG 1”, I want the status to read “Report 1”. But if there is also a note that says “qEEG 2”, I want that to read “Report 2”.
I am wondering if the solution lies in a Gantt chart (which is new to me) or if I should play with nested If statements, or both.
Here is the base:
