Maker and checker approval handling

[NiranjanK1]

Hi All,

I have multiple events to manage on a daily basis, which require approvals from both the maker and the checker before they can be considered completed. Here’s the logic I need to implement:

Once an event is completed by the maker, it should not appear in their Excel sheet but should instead move to the checker's bucket.
If the event is completed by both the maker and the checker, the status should be updated to "Event Completed," and it should then be transferred to the completed Excel sheet.
If the event is completed by the maker but not approved by the checker, it should return to the maker's bucket for rework.

I am having difficulty moving the data according to these statuses. How can I resolve this issue.

Event ID	Maker	Checker	Maker Status	Checker Status	Event Status
1	User1	User2	Complete	Pending	Pending Process
2	User3	User4	Complete	Complete	Event completed
3	User5	User6	Pending	Pending	In progress
4	User7	User8	Complete	Reject	In progress

Data sample: 

Date	Processing Status	Event Id	Number	Column1	Column2	Column3	Column4
5/8/2025	Pending Process	123	452	ExD-1	ExD-1	PayD	ExD+1

Thanks in Advance
Nr

[NiranjanK1]

@Hsandness Thanks a lot for the logic, the challenge is I need to update the status in one file and based on status i have to move the data into different folders

Makers and checkers each have their own separate folders containing their respective lists of events. 

    Once a Maker completes their tasks, they will pass the list to the Checker. 

    After the Checker finishes their review, they will return the list to the Maker for verification. 

I need to save a single file with all the complete data. As these individuals make updates, I will also update the status accordingly. 

   When a Maker completes a task, I will remove the completed ID from their folder and move it to the Checker’s folder. 

   I need to save the data in YXDB format to track the status from each folder, and ultimately, I will update everything in one file.