Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
COUNTIFS to ignore "#Missing or Invalid Paramaters"
hello,
I have a column that use "Networkdays" to calcuate the "Start" and "End date" of a row. Example:
Project Name: Start Date: End Date: Duration
-----------------------------------------------------------------------------------------------------------------------------
Project A 11/16/2015 11/17/2015 2
Project B 11/16/2015 #Missing or Invalid Paramaters
I would like to use the COUNTIFS or COUNT to count the "Duration" column and ignore the "#Misisng or Invalid Paramaters".
I am getting the #BLOCKED return instead of 1. Please help. Thank you
Comments
-
Hi Dan, formulas will return an error if they reference cells that contain an error. I would add a condition to the formula that is producting the the #MISSING OR.... error that will display a blank cell if that condition is met (for example, of there is no end date, display a blank cell rather than an error).
=IF(ISBLANK(EndDate1), "", .......
-
yep. Thank you.
=IF(AND(ISDATE([Begin Packaging]11), ISDATE([Complete Packaging]11)), NETWORKDAYS([Begin Packaging]11, [Complete Packaging]11, $Holidays$144:$Holidays$156))
