I haven't used SharePoint Designer Workflows for a while - but I think the workflow creates a column in the library, right? It looks like that can't be used in a calculated column, however, I just checked that on an old library that I'd had a workflow on. I wonder if in each of your different workflows, you could add a step to check the values of the other workflow columns, and if they are = approved, set a different column to approved. I'm not sure that will work, but it's where I'd start. Oh - another thought. You could use an additional helper column and increment an int value there as each workflow hits approved. So in the workflow, set "Counter" to its value plus one. Then, your single "Approved" column could be calculated - if Counter = 3 show "Approved" and if not, show blank or "In Progress" or something?
Hilary Stoupa
