Change 'Status' Column based on date past
I've searched for this a few times but cannot find a solution that fits what I require.
I am trying to update a status column to show 'Being Reconciled' when a date column is in the past.
The automation feature doesn't seem to work unless rows are being manually changed.
I've created a helper (=IF(TODAY() > [Departure Date]@row, "Event Past")) and set an automation to change the 'Status' when the helper column changes to 'Event Past' but same problem, it doesn't seem to update unless I change a row.
Some previous suggestions involve creating a nested if formula for this column but I need the column to be editable so some status's require a manual update.
Is there any way round to make this possible?
Many thanks for your help.