I am looking for a hand writing a python script in the Field calc, as it looks like I am stuck. Here is a screen shot of my table:
What I need to do is populate the "status" field by parsing through each actual (act) field in order. If the recon_act field is populated, move to the Socons_act field, if that is populated, move to the stake_act field and so on. If the act field is not populated, that is the status of the project. For instance, the 15th project does not have an act date in Recon_act, so the status will be "RECON". A dozen or so down from that a project has a date in the recon_act field but not the SOcons_act field, so that status will be "SOcons".
The 4th project down has dates in the Recon_act field, Socons_act field, stake_act field but not the plat_act field so that status will be "PLAT".
In my brain, the python statement needs to look something like this:
If [recon_act] = ‘ ‘ then Status = “RECON”
Elseif [SOcons_pro] = ‘ ‘ then Status = “Socons”
Elseif [stake_act] = ‘ ‘ then Status = “STAKE”
Elseif [plat_act] = ‘ ‘ then Status = “PLAT”