Total % Complete for 4 columns

RobNY2

I think this formula should be easy but I am terrible with formulas.

There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns:

Formula I have is:

=SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) + IF(DATE([LAN Migration Ready Approved Actual]@row, 0.25) + IF(DATE([LAN Migration Scheduled Actual]@row, 0.25) + IF(DATE([LAN Migration Complete Actual]@row, 0.25)))))

but is wrong and I don't know how to fix it.

I appreciate any help

Thanks

Rob😙

Jeff Reisman

@RobNY2 Try this:

=(COUNTIF(ISDATE([LAN Migration Ready Actual]@row)) + COUNTIF(ISDATE([LAN Migration Ready Approved Actual]@row)) + COUNTIF(ISDATE([LAN Migration Scheduled Actual]@row)) + COUNTIF(ISDATE([LAN Migration Complete Actual]@row))) / 4

This counts how many of the columns have a date value, divides the answer by 4, giving you the percentage.

Jeff Reisman

@RobNY2 Try this:

=(COUNTIF(ISDATE([LAN Migration Ready Actual]@row)) + COUNTIF(ISDATE([LAN Migration Ready Approved Actual]@row)) + COUNTIF(ISDATE([LAN Migration Scheduled Actual]@row)) + COUNTIF(ISDATE([LAN Migration Complete Actual]@row))) / 4

This counts how many of the columns have a date value, divides the answer by 4, giving you the percentage.

RobNY2

Thank you very much! 😀