Updating Status When Record is Updated

[VLMark37]

I would like to automatic "status" changes to record when certain columns are updated.

I am working on a new app.  I already have action buttons set up to update status manually ("Not Started","In Progress", "Compete"); however, I would also like to add auto updates as well.

The a new record defaults to "not started".  I want the record to "In progress" when a transporter is assigned.

ISNOTBLANK([Transporter ID])

When Tank ID is selected or ISNOTBLANK([Tank ID]), I would like the status to move to "Complete".

Any suggestions?

Thanks,

Lee