IFERROR not working correctly

Christy Kooiman

I'm trying to use the IFERROR function and it doesn't seem to be working. I have two cells feeding off of each other and I'm not sure if that's playing into it. We have one cell that they can pick the quarter or it will automatically fill in if there is a date plugged in. I also have it set up to fill in a date if the Quarter is picked.

Here is my formula for the Quarter Column but when I hit enter it still says, "#Circular Reference". I know it's a circular but I just wanted different verbiage there.

Here is the formula for my date column. When I hit enter it still says "#Blocked", which again is expected but I want to change the verbiage again.

Am I not able to do that since it's a circular reference?

Thanks in advance!

Kelly Moore

Hey @Christy Kooiman

The only way I've ever gotten this to work is with a helper column that mirrors one of the columns and I point to that. So I wouldn't have Quarter referencing the real Date column, but mirrored Date column.

Kelly

Kelly Moore

Hey @Christy Kooiman

The only way I've ever gotten this to work is with a helper column that mirrors one of the columns and I point to that. So I wouldn't have Quarter referencing the real Date column, but mirrored Date column.

Kelly

Christy Kooiman

Thank you!