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😙
Best 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.
Regards,
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!
Answers

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

Thank you very much! 😀
Help Article Resources
Categories
Check out the Formula Handbook template!