#Invalid Data Type: If Countifs Children Rows
Hello Smartsheet Community,
I've spent several hours trying to determine the source of the #Invalid Data Type error that appears only under certain conditions. Context: I'm using this formula as a helper for conditional formatting and it works perfectly in some instances but I get #Invalid Data in others. Many, many tests later it seems that if the Finish dates are too far in the past, the error occurs, but not if some children Finish dates are today or in the future. This might be a fluke, but I truly can't find any other common denominator.
=IF(COUNTIFS(CHILDREN(Finish@row), <TODAY(), CHILDREN(Status@row), <>"complete"), 1, 0)
See below: 2 screenshots of the same sheet, just changed the start date and boom, no more error...
Important to note that when the formula does work, Helper successfully generates a '1'.
Any idea how I can fix this?
Start date: October 2020
Start date: April 2021
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!