IF Statement Returning Incorrect results

BethWork

I tried the AI feature for writing formulas and it gave me a slight variation of the formula below. I want it to look at the Discovery Completed column and if the box is checked then it should display the information in the cell for the Implementation Project Stage. If the box in Discovery Completed is not checked then it should display the information in the cell for Discovery Project Stage.

When I use the formula below it returns the information backwards.

How can I alter the formula below to have it correctly return the data from separate cells/columns?

=IF([Discovery Completed?]1, [Implementation Project Stage]@row, [Discovery Project Stage]@row)

Nic Larsen

Try:

=IF([Discovery Completed?]@row = 1, [Implementation Project Stage]@row, [Discovery Project Stage]@row)

Nic Larsen

Try:

=IF([Discovery Completed?]@row = 1, [Implementation Project Stage]@row, [Discovery Project Stage]@row)

BethWork

That was it! I needed to add the @row into the statement.