Time formula help please

Hi I am having trouble working out the following.

When “delivered” is written in the status field I would like “Late” to appear in the PO field after 48 hours and be blank otherwise.

Hope this is clear enough, fixing this would be amazing.

Jos

Welcome to the community, @Jos_Bingham! :smiley: First add a last updated time field that only looks for changes to your {Status} field. I’ll refer to this as the {Status Updated} field. In the {PO} field, this would be the formula:

IF(
  AND(
    Status = "Delivered",
    NOW() > DATEADD({Status Updated}, 48, "hours")
  ), "Late"
)

The only issue is that if the status ever changes from “Delivered” to anything else, that “Late” indicator will go away. If you want the “Late” indicator to stay, you’ll need to use an automation. The setup would be similar. The trigger mechanism would be a formula field:

AND(
    Status = "Delivered",
    NOW() > DATEADD({Status Updated}, 48, "hours")
)

For the trigger step of the automation, use “When record matches conditions”, with the condition being that this formula output = 1.

The only action needed is “Update record”, choosing the triggering table and record, and setting the {PO} field to “Late”.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.