Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 19, 2021 03:57 PM
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:
If “services” = Pre & Post” or “4 Part”
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:
Aug 01, 2021 11:51 PM
Hi @JoJo_Yonce and welcome to the community!
Did you try working with a simple formula field and IF() or SWITCH() to determine the “status” and then start from there?