IFERROR not working correctly

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!

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 05/04/23 Answer ✓

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!