Forum Discussion
MarkShnier__You
Qrew Legend
So, you can just look that up down to the Support Tickets, but my suggestion is to convert it to a vertical list.
You can make a formula text field I made a syntax correction in bold.
SerachAndReplace(ToText([Combined Text Summary Phase Summary]), " ; ", "\n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can make a formula text field I made a syntax correction in bold.
SerachAndReplace(ToText([Combined Text Summary Phase Summary]), " ; ", "\n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JaimeStrawderma
5 years agoQrew Cadet
Hi Mark,
I've been pretty busy lately but just back to working on this. Everything works well as far as returning information into a single report. I just need help with the formatting a bit please. For example, I have a project with 6 Phases and thanks to your formula those show up in a vertical format. However, the Phase Status only shows the three statuses, Active, Completed, and Inactive. Is there a way to line up the correct status with the correct Phase? Thanks!
------------------------------
Jaime Jaime
------------------------------
I've been pretty busy lately but just back to working on this. Everything works well as far as returning information into a single report. I just need help with the formatting a bit please. For example, I have a project with 6 Phases and thanks to your formula those show up in a vertical format. However, the Phase Status only shows the three statuses, Active, Completed, and Inactive. Is there a way to line up the correct status with the correct Phase? Thanks!
------------------------------
Jaime Jaime
------------------------------
- JaimeStrawderma5 years agoQrew CadetExcellent. Works like a charm. Thank you so much for all of your help.
------------------------------
Jaime Jaime
------------------------------ - MarkShnier__You5 years agoQrew Legendnp,
easy solution.
make a field down at the child level which combines the Phase and the Status.
List(" - ", [Phase], [Status]) and change the target field for your Combined text summary field to look at that field instead. That way the two fields will stay together as they get rolled up.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------