IFERROR not working
Answers
-
Ok. And can you provide a screenshot of the column settings for the [Task Status] column? The particular error that is being generated is what is throwing me off.
-
-
Let's try this...
=IFERROR(INDEX(CHILDREN([Task Steps]@row), COUNTIFS(CHILDREN([Task Started]@row), <> "")), "")
-
Hhmmmmm....this formula still calculates the Task Status correctly but when there are not dates in the children Task Done cells I still get the error. It's referencing the parent row for dates.
-
What do you mean by your last statement of
"It's referencing the parent row for dates."
-
I have another idea...
=IF(COUNTIFS(CHILDREN([Task Started]@row), <> "") = 0, "", INDEX(CHILDREN([Task Steps]@row), COUNTIFS(CHILDREN([Task Started]@row), <> "")))
-
THANK YOU!!!! That worked. Now the field is blank unless dates are entered. Just what I needed. Appreciate it sssoooo much!
Jeana
-
Great!! Happy to help! 👍️
To explain how it works... Instead of trying to do the calculation and account for an error, we first counted the cells that are not blank. If that count is zero (all cell are blank), we generate a blank. This means that it will not run the error causing portion until there is at least one date, and as long as you have at least one date, there is no error to worry about.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!