All,
I have multiple business units in one column and a work status on another column.
I have created archive sheets for all BUs and I want to use an automation for when the work status says Done, it moves the row to that BUs specific archive. for example
BU: Dominos Work Status: Done
this moves it to Dominos' specific archive sheet
BU: Hut Work Status: Done
this moves it to Hut's specific archive sheet