@iron hazel thanks for answering in the other thread, I'm making it into a separate one instead of messaging you directly so we keep it public in case other people are looking for this!
The reason why there's a different status column for the workflows is because I can't customise the published / draft statuses within Payload. If you want to sync the published status with the workflow status I'd suggest you use hooks (https://payloadcms.com/docs/hooks/collections)
So for example: Within a hook you look for any changes in the "workflowStatus" field, if the workflowStatus has reached for example "Published", you update the publishedStatus (the one provided by Payload) to "published" as well.
as you mentioned, we were able to sync the workflow status using hooks and that works fine, but now we're in a situation where if something is already published via the workflow and we try to unpublish via the regular Payload mechanisms (clicking the "Publish" button in the collection or the "Unpublish" link underneath) we don't get any updates and the entity remains published. I'm guessing this is due to not being able to customise the behaviour of the Payload buttons to hook them to the workflow status as well, right? do you have any suggestions?