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
-
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
-
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
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!