Is it possible to automate the update to current status column? I need the status text only. thanks

Maryjo Reyes

Bassam Khalil

Hi @Maryjo Reyes

Hope you are fine, do you mean that you want the latest status to be displayed in the current status column, for example in row 1 = Payment Received because it's the latest status. if this is what you mean please use the following formula:

current status = if(ISDATE([Date Payment Received]@row), [Status 5]@row, if(ISDATE([Date Approved ACCNT]@row), [Status 4]@row,if(ISDATE([Date Approved BD]@row), [Status 3]@row,if(ISDATE([Date Approved CPCAD]@row), [Status 2]@row,if(ISDATE([Date Approved PDMG]@row), [Status 1]@row,""))))))

Maryjo Reyes

Hello @Bassam.M Khalil,

Thanks for your reply. Yes that's what I mean to get the latest status in each rows.

Using your formula it gives me #UNPARSEABLE.

Thank you.

Bassam Khalil

Hi @Maryjo Reyes

Could you please export your sheet to excel and attach it here ( remove any sensitive data ) the error because of the column name. i will give you the exact formula.

Maryjo Reyes

Draft101.xlsx

Hi @Bassam.M Khalil,

This is just a draft in excel format. Thanks

Bassam Khalil

Hi @Maryjo Reyes

Please check the following formula

=IF(ISDATE([Date Payment Received]@row), [Status 5]@row, IF(ISDATE([Date Approved ACCNT]@row), [Status 4]@row, IF(ISDATE([Date Approved BD]@row), [Status 3]@row, IF(ISDATE([Date Approved CPCAD]@row), [Status 2]@row, IF(ISDATE([Date Approved PDMG]@row), [Status 1]@row, "")))))