IFERROR not working

Options
Jeana
Jeana ✭✭✭✭✭✭

This seems pretty straight forward for me but it's not working. I want to add an IFERROR to this formula which is determining and displaying a status of several children steps in a process. I don't want the INVALID COLUMN VALUE to show initially as it does now, until they enter a date. I want it to be blank until they enter a date. :-)

=INDEX(COLLECT(CHILDREN([Task Steps]@row), CHILDREN([Task Started]@row), ISDATE(@cell) = "True"), COUNT(COLLECT(CHILDREN([Task Steps]@row), CHILDREN([Task Started]@row), ISDATE(@cell) = "True")))


This isn't working:

=IFERROR(INDEX(COLLECT(CHILDREN([Task Steps]@row), CHILDREN([Task Started]@row), ISDATE(@cell) = "True"), COUNT(COLLECT(CHILDREN([Task Steps]@row), CHILDREN([Task Started]@row), ISDATE(@cell) = "True"))), " ")

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!