Hello,

The following formula populates a calculated column [Status] with "Initial" if both [RefA] and [Ref B] are blank, and "Raised" if both are populated:

Formula: =IF(AND([Ref A],[Ref B]=""),"Initial","Raised")

Fairly simple so far, however I also have a column called [Resolved] of type 'Yes/No (check box)', which, once checked, should update [Status] to "Resolved", providing that the current value of [Status] is "Raised".

I thought about creating a hidden column [Hidden Column] which would calculate:

Formula: =IF([Resolved]="Yes", "Raised", "Anything")

The idea behind this is to convert 'Yes' to "Raised", so that I can now compare [Status] with [Hidden Column]. If the values match i.e. both [Status] and [Hidden Column] are equal to "Raised", then [Status] will change to "Resolved".

This is proving to be a bit troublesome because I have three statuses: "Initial", "Raised" and "Resolved". My first formula works well, but I can't seem to integrate the second part. Can I use a nested function to make this possible? I'm not even sure that creating a hidden column helps the situation as it is the [Status] column that is being affected.

Any help would be greatly appreciated.

Kind Regards,

David.