Formula produces #CIRCULAR REFERENCE

felixo

I'd like to compare the dates in two rows, i.e. Ende (Plan) and Ende (nach Verschiebung). If Ende (Plan) is older than Ende (nach Verschiebung) the date should change to red colour (or somehow be highlighted).

The AI tool in Smartsheet proposed the following formula =IF([Ende (Plan)]@row < [Ende (nach Verschiebung)]@row, "Red", "") but it produces a #CIRCULAR REFERENCE.

How should the correct formula look like?

Paul Newcome

The formula needs to go into a different column. You would then need to leverage conditional formatting based on the new column to get the cell or date to highlight red.

Paul Newcome

The formula needs to go into a different column. You would then need to leverage conditional formatting based on the new column to get the cell or date to highlight red.

felixo

Many thanks Paul, your answer was very helpful to solve my problem!

Paul Newcome

Happy to help. 👍️