Also, just to elaborate on the formula a little bit

Tracy, I could be misunderstanding your request, but I think the grouping row information is possible. It would look like this: group.0.valueexpression=CONCAT({project}.{name}," - (",{project}.{DE:Brief Status and Summary},")") Not sure what happens if the Brief Status and Summary is lengthy though,...

Hi Mollie! Our company doesn't use program reports, so I'm not super familiar with how they work, but I can speak to the project-level calculated field. I think this formula should work for what you need:DMAX(Program.Name of Field,Program.Name of Field,Program.Name of Field) To explain the formula:...

Hi Tracy! Did you figure out a solution for this? I'm looking to do the same thing that you described above. Thanks!Chloe

I just tested this out with CONTAINS and it seems to work: SUM(IF(CONTAINS(Multi-Select Field,valueX),1,0),IF(CONTAINS(Multi-Select Field,valueY),1,0),IF(CONTAINS(Multi-Select Field,valueZ),1,0))

Laura - if you're still having issues, I find that sometimes when I copy and paste codes from the internet, I need to delete the spaces between the statusEquatesWith statuses (PLN CUR ONH APR) and redo the spacing using the tab key. Just an idea! That has definitely tripped me up before. Text mode c...

We have something similar, but it uses SUM and IF. I would imagine you could swap "IF" for "IFIN" though. Essentially, we set the true statement to the value "1" and the false statement to "0". That way, if true is met, it counts for 1 point, if false is met, it counts for 0 points. Then the SUM fun...