I need to explore building a custom workflow in Designer that will allow me to update a hidden field in the list. Is it possible for me to recreate the nested IIf statement I have written below? I'm not seeing how to do get an AND operator in the workflow designer, nor the nested concept.
TypeOfChange: IIf([status]="active",
IIf([program type]="p", "Primaries Approved",
IIf([program type]="o", "Options Approved",
IIf([program type]="R" Or [award]="AAS-T", "AAS-T Programs Registered",
IIf([apprentice]="a", "Apprenticeships Registered",
IIf([contract]="c", "Contracts Approved",
IIf([College Report Categories]![title]="collaborations", "Collaborations Registered",
IIf([Indiv Program Students] is Not Null, Individualized Programs,
IIf([program type]="st","ST Programs Registered")))))))),
IIf([status]="Title changed", "Titles Changed",
IIf([status]="removed",
IIf([program type]="p", "Primaries Deleted",
IIf([program type]="o", "Options Deleted",
IIf([program type]="st", "ST Deleted"))),
IIf([status]="Inactive",
IIf([program type]="p", "Inactive Primaries",
IIf([program type]="o", "Inactive Options")),
IIf([status]="Reinstated", "Reinstated Programs",
IIf([status]="Pending", "Pending Requests",
IIf([status]="NoI Review", "NoI Review Period",
IIf([status]="Modified", "Curriculum Modifications",""))))))))