How to create formulas comparing two columns with multiple criteria

Nishu

I need a formula, If Closed Date column is blank, any values in Status column should retrieve blank value in Result column. If Closed Date has a date and status column has “Reopened” value then it should retrieve blank value in Result column. However, if Closed Date has a date and status column has value other than “Reopened”  then it should retrieve “N/A” value in Result column.

Genevieve P.

Hi @Nishu

Try something like this in your Result column:

=IF(OR([Closed Date]@row = "", Status@row = "Reopened"), "", "N/A")

You can also use a Change Cell Workflow to update a column, if you don't want to use a formula in every cell. See: Change the Value of a Cell in an Automated Workflow

Cheers,

Genevieve

Genevieve P.

Hi @Nishu

Try something like this in your Result column:

=IF(OR([Closed Date]@row = "", Status@row = "Reopened"), "", "N/A")

You can also use a Change Cell Workflow to update a column, if you don't want to use a formula in every cell. See: Change the Value of a Cell in an Automated Workflow

Cheers,

Genevieve

Nishu

Thanks a lot Genevieve