# Total % Complete for 4 columns

✭✭

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😙

• ✭✭✭✭✭✭

@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.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭

@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.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭

Thank you very much! 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!