A few options:

Make an automation, the trigger of which is "When record matches condition..." and set that condition to be Status=Sold

Alternatively, create a view that only shows Status=Solid records. Then create an automation for "When record enters view..." and select that new view.

Then you add an action to the automation to send your email. 

I dont think you need to do anything with Zapier or Make 

Thank you so much for helping. I left out a key bit of information. There are other selections in the single select. I need it to only happen when one of the selections goes to Sold, not when the other selections do. That's why I was having trouble with my normal methods. Any advice? Thanks!

Funny -- I thought that might have been what you meant!

There are probably a bunch of ways to do this, but here's one that I think should work. It's based on creating a box you check when teh first step in the process happens -- basically creating a change record. 

Steps:

• Create a new checkbox field: flag_last_status_change_was_to_C
• Create a "When Record is Updated" automation that watches for changes to Status and then does a conditional action:
  • If Status=Option C, it checks the box in flag_last_status_change_was_to_C. 
  • If Status is Option A or B, it unchecks the box.
  • If Status=Option D, do nothing.
• Create a second automation that looks for records that where Status=Option D and flag_last_status_change_was_to_C=true, and if so, send your email.
• (I'd probably also create a flag_C_to_D_email_sent checkbox field and check that once the email is sent and explicitly exclude flag_C_to_D_email_sent=true from my second automation. I tend o do that kind of thing as a way of avoiding inadvertently triggering a zillion automations by mistake.)

Hope that helps!

D

Hi,
to catch C > D

 you have 2 options:
1) create hidden field, text or checkbox. create two automations, when record matches condition:

Select is Choice C = put '1' to hidden field
Select is none of C,D = put '0' to hidden field
then create third automation - Select is D and hidden field is 1 - that will be your main automation.
Don't forget to include step 'put "0" to hidden field' in your actions.

2)create view where Select is not Choise C, 
create automation 'when record enters view'
insert conditional group of actions, condtition must check that Select is Choise D
it will not run for A > D (for example) because record will stay in view all time. But if you change Select to Choise C, record will be filtered out. And then enter view again if you select other choice.
(pros: you need just one automation, no need to create additional hidden field.
contras: your automation must include conditional group of actions (so you cannot use repeated group in it). also, automation will react to any new record in table and if record created with Select = Choice D it will run despite Select was never Choice C. But if your new record can't be created with pre-filled Choice D, you can ignore that fact.


update: didn't see a reply from dsolimini  - yeah, I think instead of 2 or even 3 you can create a single automation triggered on Select update and conditional actions

Funny -- I thought that might have been what you meant!

There are probably a bunch of ways to do this, but here's one that I think should work. It's based on creating a box you check when teh first step in the process happens -- basically creating a change record. 

Steps:

• Create a new checkbox field: flag_last_status_change_was_to_C
• Create a "When Record is Updated" automation that watches for changes to Status and then does a conditional action:
  • If Status=Option C, it checks the box in flag_last_status_change_was_to_C. 
  • If Status is Option A or B, it unchecks the box.
  • If Status=Option D, do nothing.
• Create a second automation that looks for records that where Status=Option D and flag_last_status_change_was_to_C=true, and if so, send your email.
• (I'd probably also create a flag_C_to_D_email_sent checkbox field and check that once the email is sent and explicitly exclude flag_C_to_D_email_sent=true from my second automation. I tend o do that kind of thing as a way of avoiding inadvertently triggering a zillion automations by mistake.)

Hope that helps!

D