Hi Sarah. You almost have it. Click the blue plus button and you’ll see something like “Record (from Step 1)…” Click on the blue “Continue” and you’ll see something like this:

There’s the record id that you’re looking for (select it). Then type in the value you want “Actionable” to take.
Automations work with one record at a time, but will fire as many times as the trigger conditions are met
Hi Sarah. You almost have it. Click the blue plus button and you’ll see something like “Record (from Step 1)…” Click on the blue “Continue” and you’ll see something like this:

There’s the record id that you’re looking for (select it). Then type in the value you want “Actionable” to take.
Automations work with one record at a time, but will fire as many times as the trigger conditions are met
Going through an automation to achieve this functionality is overcomplicating things. A more convoluted system means greater chance of failure. Not to mention the number of your monthly automation runs is capped, even on an enterprise plan.
Without redoing your whole base design, you could add a formula field to track the single-select one, then alert you if two weeks have passed without a signed contract:
IF(
AND(
{Actionable} = "In progress",
{Contract signed} = BLANK(),
ABS(
DATETIME_DIFF(
{Date sent}, TODAY(), "days"
)
) > 13
), "call"
)
Mockup:

EDIT: Just realized I called one of the single-select options “Contract signed” in my example, don’t let that confuse you.
Oh, and welcome to the community, @augmented!
Going through an automation to achieve this functionality is overcomplicating things. A more convoluted system means greater chance of failure. Not to mention the number of your monthly automation runs is capped, even on an enterprise plan.
Without redoing your whole base design, you could add a formula field to track the single-select one, then alert you if two weeks have passed without a signed contract:
IF(
AND(
{Actionable} = "In progress",
{Contract signed} = BLANK(),
ABS(
DATETIME_DIFF(
{Date sent}, TODAY(), "days"
)
) > 13
), "call"
)
Mockup:

EDIT: Just realized I called one of the single-select options “Contract signed” in my example, don’t let that confuse you.
Oh, and welcome to the community, @augmented!
Thanks for the welcome, though I’ve been here awhile. And I do like your idea of foregoing the automation!
However, I think showing someone how to update a record through an Action could come in handy for them in the future.
Thanks for the welcome, though I’ve been here awhile. And I do like your idea of foregoing the automation!
However, I think showing someone how to update a record through an Action could come in handy for them in the future.
I actually wanted to tag the OP, @Sarah_Fleming, but it seems writing that formula exhausted all my brain power.
Totally agreed btw: