Change 'Status' Column based on date past

Hello,

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.

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Paul Newcome

Set up your automation to be triggered daily and include a condition of that date being in the past.

Kaveri Vipat

Hi justdan2,

I have created a helper column and applied your formula “=IF([Departure Date]@row < TODAY(), "Event Past", "")” and also set an automation to change the status when the helper column changes to ‘Event Past’, so my formula and automation are working, please try the formula and automation.

=IF([Departure Date]@row < TODAY(), "Event Past", "")

Hope it will work for you.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.