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



Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @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

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!